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.
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?Please Login or Register to view this content.
Here is the code for the button in the worksheet:
and from the userform:Please Login or Register to view this content.
Thanks!Please Login or Register to view this content.
Bookmarks