How should macro call VBA function and test the return value? (1 Viewer)

I have a button with embedded marco (using macro builder). The macro carries out a series of actions/command. One of actions is to call a vba function.

The intention is for this vba function to return a value back to the macro which will then carry a series of action based on the returned value.

However I have problem in achieving this. I have tried a number of ways but with no success. Below is one way I tried.

In the macro:

RunCode myFunction(myInt)
If myInt = 1 Then
RunMenuCommand .....
Else if myInt = 2 Then
RunMenuCommand .....
Else
RunMenuCommand....
End If


In the VBA function:

Public Function myFunction(myInt As Integer) As Integer

myFunction = .....

End Function


I know what I am asking is probably a simple question but as I am new the access I am still trying to learn the basic.

Any help and advice will be greatly appreciated. Thank you!

Returning Val's in macros is kinda a pain.
You must build IF blocks, where everything in the block has an ellipsis in the box.
Look this up on how to do it.

Ranman256 said:

Returning Val's in macros is kinda a pain.
You must build IF blocks, where everything in the block has an ellipsis in the box.
Look this up on how to do it.

Click to expand...

Hi Ranman256.

Thank you for responding. Seems like you were going to include some links or codes that might have been left out. Would you be able to provide those information please? Thank you.

first is you create local variable in your macro (SetLocalVar). use your function to return the value. test the result with IF [yourLocalVarName] = ....

Thank you arnelgp. Got it working! Thank you again