Adding a button to a spreadsheet...

P

PokerZan

Hello,

I am trying to figure out how to add a button to a spreadsheet that
will launch the UserForm that I have created for inputing data onto
that ss.

This has to be easier than it is to find out how to go about doing
this.

Thanks,


PZan
 
C

CyberTaz

Hello-

Depending on version & intent you can either bring up the Forms Toolbar and
create your button using the Button tool and assign a Macro to it then or
later.

Or, you can turn on the Control Box Toolbar & use the Command Button tool to
create the button and write your VBA.

HTH |:>)
 
B

bigwheel

First, enable the Forms toolbar (View>Toolbars>Forms) Then click the "Button"
button and drag on the sheet to the size you want, then assign the macro to it
 
Top