How to open a userform with a button ?

[AnthonyWB]

A very quick question. I have a userform called "Automation". I have a button on a worksheet called FASB 157 Automation in a workbook called called 157_Disclosure_Automation.xlsm. I would like to apply VBA code to the button so that it opens the userfrom.

I tried this and it does not work.

Please Login or Register  to view this content.

Any suggestioons ? Thanks

[Domski]

Please Login or Register  to view this content.

You should be able to just pop that code in a module and attach the macro to a button from your Forms toolbar.

Dom

[solnajeff]

Hi

Enter design mode, double click on the button and you will be taken to the VBE with the cursor in the relevant code, e.g.

Please Login or Register  to view this content.

. At the cursor enter your code

Please Login or Register  to view this content.

and you are good to go.

Regards

Jeff

[romperstomper]

Please Login or Register  to view this content.

[AnthonyWB]

Domski and solnajeff, thanks it works perfectly.