run code from menu

[Jesper F]

I'm building menu bar. Can run some code from a menu item without opening af
form?
Just run say a function when clicking the item?

Jesper

 

[Rick Brandt]

I'm building menu bar. Can run some code from a menu item without
opening af form?
Just run say a function when clicking the item?

Jesper

Enter...

=FunctionName()

....in the OnActionproperty of the menu item. It has to be a function or a
macro, not a sub.

 

[Jesper F]

Enter...

=FunctionName()

...in the OnActionproperty of the menu item. It has to be a function or a
macro, not a sub.

Thanks very much !!

 

[PC Datasheet]

Further ------

FunctionName() can be in a form's module if the form will be open when you
run the function. Otherwise, you will need to put FunctionName() in a
standard module.