Resolved - calling button code by menu item click

[santosh66]

I have a working button code.
I would like to call same by clicking menu list item.
how do I do it?

[Merri]

Private Sub mnuFileNew_Click()
    Command1_Click
End Sub

Edit Ha! Faster by three minutes!

[lintz]

Try this....

Private Sub YourMenu_Click()
'Call Working Button Code
 
'If the code is in the click event of a button try this
MyButton_Click
End Sub

[Spajeoly]

You can also say....

Command1.Value = True

Though I know of no one else who does it like that

[brucevde]

I use the Value property to fire the click event.

[baja_yu]

But if you have code in any other events put them instead of Click, like:

Command1_KeyPress
Command1_MouseDown

etc...

[pnish]

Originally posted by brucevde
I use the Value property to fire the click event.

Ditto here. So Spajeoly you now know 2 people who do it that way.