How to evoke a hidden userform?

  • Thread starter Thread starter Flippi
  • Start date Start date
F

Flippi

Hello,

Thanks to this forum, I managed to create my 1st userform. It pops up
when I open my workbook and I'm able to add data to my workbook by
means of list boxes and a command button. After clicking the command
button, all data is added and the userform is hidden.
When I want to use the userform again, I have to save my work, close
the workbook and re-open it.
There's probably a way to add an item to the menu to display the
userform without closing and re-opening the workbook. How should I do
this? Examples somewhere?

Thanks in advance,

Flippi
 
Just add a command

Userform1.Show

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top