Connecting userforms to buttons in Excel
 

I want to define a button in Excel (close to the bold- and italic-buttons)
that opens a userform that I have done. (In this userform I can do some
settings before I press the OK-button to start the VBA-macro thats does the
work.)

I know how to connect a button to a VBA-macro, but not how to connect it to
a userform.

Best regards,
/Sören

Connecting userforms to buttons in Excel
 

Create a macro to call the form and run the macro from your button...
'--
Sub ConnectToUserForm()
UserForm1.Show
End Sub
'--

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sören_Marodören"
wrote in message
I want to define a button in Excel (close to the bold- and italic-buttons)
that opens a userform that I have done. (In this userform I can do some
settings before I press the OK-button to start the VBA-macro thats does the
work.)
I know how to connect a button to a VBA-macro, but not how to connect it to
a userform.
Best regards,
/Sören