User form RTE 13 when opening with a command button on a worksheet

[iaingidley]

Hi,

I have created a userform that allows users to enter data into a database spreadsheet. When I run a macro called showUserForm from the macro menu or from inside VBA the userform opens and runs properly.

Please Login or Register  to view this content.

However, I would like users to be able to open the userform from excel with the click of a button, without having to goto the macro menu, or press a combination of keys. When I add a command button to the worksheet I get a RTE 13 'type mismatch' when trying to open the user form. I have tried changing the name of the command buttons in the sheet and in the user form so they don't conflict but am having no luck. Any ideas?

Here is the code for the button in the worksheet:

Please Login or Register  to view this content.

and from the userform:

Please Login or Register  to view this content.

Thanks!

[romperstomper]

Try:

Please Login or Register  to view this content.

[Mordred]

Try:

Please Login or Register  to view this content.

[Mordred]

Dang, I thought I was getting it done quickly. Not as quick as romperstomper though!

[iaingidley]

Solved! Thanks guys. What mistake was I making with my code?

[romperstomper]

Unnecessary selection. It is almost never necessary to select anything in order to use it, and can get you in trouble. Since by default ActiveX buttons take focus when you click them, I suspect the Selection was not what your code needed it to be (a Range) but was still the button.