going from excel spreedsheet to vba userform

Topic

New Reply

i have a user form (vba) that inputs data into the spreedsheet. but when i exit out of the userform and go into the spreedsheet there is no way for me to bring back up the userform. I have to close out of what i’m doing and reopen it. there has got to be a better way of doing this?

Reply | Quote

Replies

How about adding a macro called DisplayForm with the single line of code:

USERFORM1.Show

You could call it using the Macros dialog, or (in 2000-2003) assign it to a menu or toolbar or (in 2007-2010) assign it to the Quick Access toolbar.

Reply | Quote

don’t know why I didn’t think of that…. thanks buddy.

Reply | Quote