Attach an existing VBA sub to a new button

[JimL]

I have looked at various searches on this but have not been able to determine how to create a button and then associate it with an existing VBA sub.
`
Can anyone help, please?

Thanks

 

[pbaldy]

If the function/sub is in a standard module, you just call it by name:

http://www.baldyweb.com/Function.htm

If it's an existing event procedure (which I personally wouldn't do), you have to make it public and then call it like

Forms!FormName.Command3_Click

 

[theDBguy]

Hi. If you have a certain procedure that needs to be executed from multiple events or scenarios, you might consider moving it to a Public Sub or Function.