Function Returning Boolean?

Question

I have simple function in VBA and I would need to check whether or not it has been successfully performed. I do not know VBA much, so I have no idea whether or not its possible. I want to do something like this: bool X=MyFunction().

I am using VBA in the QTP descriptive programming. This does not work:

Function A as Boolean
   A=true
End Function

It says: Expected statement

But I cannot see any return type in my method etc.

score 31 · Accepted Answer · answered Jun 07 '11 at 12:21

31

function MyFunction() as Boolean
    .....
    .....
    MyFunction = True 'worked
end function

dim a as boolean = MyFunction()

answered Jun 07 '11 at 12:21

Rene de la garza

1,259
1
8
7

codeape · Answer 2 · 2023-07-20T05:57:07.407

12

In VBA, you set a function's return value by assigning to a variable with the same name as the function:

Function MyFunc() as Boolean
    MyFunc = True
End Function

edited Jul 20 '23 at 05:57

answered Jun 07 '11 at 12:20

codeape

97,830
24
159
188

Thanks, I have not written its VBA inside of QTP. When I try this, it says "Statement expected". – Mirial Jun 07 '11 at 12:22
Quick Test Professional from HP. – Mirial Jun 07 '11 at 12:26
1

Then you're using VBScript, not VBA. VBScript Function Statement documentation: http://msdn.microsoft.com/en-us/library/x7hbf8fa – codeape Jun 07 '11 at 12:50

score 4 · Answer 3 · answered Jun 07 '11 at 12:44

I suspect you may be using VBScript instead of VBA? If that's the case then VBScript doesn't state Type

this will work in VBScript

dim test,b
test = 1
b=false
msgbox ("Calling proc before function test=" & test)
msgbox("Calling proc before function b=" & b)
b = A(test)
msgbox ("Calling proc after function test=" & test)
msgbox("Calling proc after function b=" & b)

Function A(test)
test = test +1  
A=true
End Function

or in your example

Function A()    
A=true
End Function

score 1 · Answer 4 · answered Jun 07 '11 at 12:28

There is no real way to check if a function worked in VBA. You must decide for yourself whether your function was successful. For example:

Function AFunction() as Boolean
    on error goto 1
    MyFunc = True
    AFunction = True
    Exit Function
    1
    AFunction = False
End Function

The above would let you know if the function failed. If it fails, it goes to the label '1' and then returns false, otherwise, it returns true.

If it isn't an 'error' you are looking for, then you must decide if the data returned or supplied is proper. One way of doing this is to return a specific value [error-code] which represents a failure.

score 0 · Answer 5 · answered Jun 07 '11 at 12:22

0

Well if you have access to your function declaration, you can set a bool return type for it and return true or false depending on the execution. Once your function returns a bool, your code will work.

answered Jun 07 '11 at 12:22

chamel

367
4
16

Function Returning Boolean?

5 Answers5

Linked