<div>
in your macro, place<br />
<br />
Action<br />
Runcode<br />
<br />
<br />
<br />
Function Name &nbsp;NameOfFunction()
</div>


in your macro, place

Action
Runcode



Function Name  NameOfFunction()

<div>
Or get rid of the macro and call it in VBA<br />
<br />
Private Sub cmd_YourButton_Click<br />
<br />
&nbsp; &nbsp; Call NameOfFunction<br />
<br />
End Sub<br />
<br />
Or if it returns a value, as all functions should, otherwise they should be subroutines<br />
<br />
Private Sub cmd_YourButton_Click<br />
<br />
&nbsp; &nbsp; 'assumes the function returns an integer<br />
&nbsp; &nbsp; Dim intRetValue as integer<br />
<br />
&nbsp; &nbsp; intRetValue = NameOfFunction()<br />
<br />
End sub<br />
<br />
<br />
<br />
<br />

</div>


Or get rid of the macro and call it in VBA

Private Sub cmd_YourButton_Click

    Call NameOfFunction

End Sub

Or if it returns a value, as all functions should, otherwise they should be subroutines

Private Sub cmd_YourButton_Click

    'assumes the function returns an integer
    Dim intRetValue as integer

    intRetValue = NameOfFunction()

End sub






<div>
I get the error: The expression you entered has a function name Microsoft Office Access cannot find.<br />
<br />
In Visual Basic I have this code in Module1:<br />
Public Sub Test()<br />
MsgBox &quot;Test&quot;<br />
End Sub<br />
<br />
In the Macro editor I have:<br />
Action &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arguments<br />
RunCode &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Test()<br />
<br />
Thanks for your help.
</div>


I get the error: The expression you entered has a function name Microsoft Office Access cannot find.

In Visual Basic I have this code in Module1:
Public Sub Test()
MsgBox "Test"
End Sub

In the Macro editor I have:
Action                      Arguments
RunCode                  Test()

Thanks for your help.

<div>
<div class="content wysiwyg-content">
How do I call a function created in Access 2007 Visual Basic with a Macro?<br />
<br />
In a test database I created a simple Global function to display a message box. &nbsp;Now I want to display it by calling it with a macro assigned to a command button.<br />
<br />
Thanks,<br />
Brooks
</div>
</div>


How do I call a function created in Access 2007 Visual Basic with a Macro?

In a test database I created a simple Global function to display a message box.  Now I want to display it by calling it with a macro assigned to a command button.

Thanks,
Brooks

Access 2007 function call from Macro

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.