Custom menu Item

[Rick]

I have a command button on a form that runs VB code in a Private sub. What
I'd like to do is set a menu item to do the same thing. I think this can be
done with the " On Action" control from the properties menu on the
"customize" menu, I'm just not sure how.

Rick

 

[Rick Brandt]

I have a command button on a form that runs VB code in a Private sub.
What I'd like to do is set a menu item to do the same thing. I think
this can be done with the " On Action" control from the properties
menu on the "customize" menu, I'm just not sure how.

Rick

Put your code in a function (not a sub) in a standard module and then use...

=FunctionName()

....in the menu item's OnAction property.

 

[Rick]

Okay Rick. You lost me. How do I set up a function?

 

[Rick Brandt]

Okay Rick. You lost me. How do I set up a function?

In your VBA code instead of..

Sub SubName
(code)
End Sub

....use...

Function FunctionName
(code)
End Function

 

[Rick]

Thanks Rick. That's just what i needed.

In your VBA code instead of..

Sub SubName
(code)
End Sub

....use...

Function FunctionName
(code)
End Function