Connecting userforms to buttons in Excel

[Sören_Marodören]

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

 

[Jim Cone]

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