Inserting a User Form created in VB Editor into worksheet.

[liam_conor]

I created a user form...I am unable to display it when I click a commandbutton on the worksheet...What am I doing wrong?...How do I do this?

 

[Mudface]

Do you have UserForm1.Show (replace UserForm1 with the name of your userform) in the Click event procedure for your command button?

If you do, you may need to right-click on the button in design mode and change it's TakeFocusOnClick property to False.

 

[liam_conor]

Thanks...you were right!