Unable to launch userform from button on worksheet

Depends on which type of "button".
If it's a "Form Control", create a small macro in a standard module with something like:

Please Login or Register  to view this content.

Then assign that macro to the button.

If it's an "ActiveX Control", place the button then double click on it (in Design Mode) to bring up the VB Editor. Add UserForm1.Show to that code and away you go.

That doesn't necessarily avoid the debug error. Could you tell us which error exactly you get and which line it highlights when you press debug?
Or even better, attach a sample workbook with the error.

BSB

Hey BSB,

thanks for the reply...already tried that bud..added a module and used code

Sub ShowForm()
UserForm1.Show
End Sub

but it get the error

"runtime error '1004'

application -defined or object defined error"

and when I hit debug userform1.show in the module gets highlighted

and directs it to

Private Sub UserForm_Initialize()
With Sheets("Database").Range("A3", Cells(Rows.Count, "A").End(xlUp))

(HERE IS WHERE IT PROMPTS THE DEBUG ERROR)

partner = Application.Transpose(.Value2)
End With

Me.ComboBox1.List = partner

End Sub

Could we see the workbook? Desensitize any confidential information.

BSB

Does the userform launch successfully from the workbook open event?

BSB

BSB,

yeah the userform launches perfect when i open the workbook...however if the userform is closed then need a way to quickly launch the userform without the user having to go into tyhe developer tab

* Norie..

Sorry about the posts will use code tags going forward

I think we'll need to see the workbook. Far easier to diagnose that way.

BSB

Try properly qualifying your ranges:

Please Login or Register  to view this content.