Attach sub procedure to Switchboard

[VBACT]

Is there any way we can set a procedure to a switchboard button?

Would appreciate any help.

Thanks

 

[fneily]

If you made your own switchboard, you used command buttons. Go to design view of the form, click on one of the buttons and bring up its property sheet. Click on the event tab and you'll see a whole bunch of events you can program. If you have a macro written, click on the box next to one of the events (usually OnClick). Click on the dropdown arrow that appears and you'll see a list of your macros. Pick the one you want. Or you could click the Button with the three dots (Build Button), click on Code builder and create some code.

Neil

 

[VBACT]

Thank you for the response. In the present stage of development I am using the switchboard manager. The switchboard manager does allow me to attach a function name to a command button, but not a procedure.

Any suggestions....?

Thanks

 

[fneily]

If you go to design view of your switchboard, you will see some buttons. They correspond to how many buttons you made from top down. Click on a button, bring up it's property sheet. On the OnCLick event something like =HandleButtonClick(,,) appears. This is a function the switchboard manager created and uses. You can click on this box and you'll see a drop down arrow. Click on the dropdown arrow and select Event Procedure. Then click on the Build Button (...). This will take you to VBA where you can write a procedure. Now when you click on this button, it will run your procedure, not the switchboard's managers.

Neil

 

[VBACT]

Thank you, Neil....Will try and let you know