Posted to microsoft.public.excel.programming
|
|
How to evoke a hidden userform?
Just add a command
Userform1.Show
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Flippi" wrote in
message ...
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
--
Flippi
------------------------------------------------------------------------
Flippi's Profile:
http://www.excelforum.com/member.php...o&userid=30351
View this thread: http://www.excelforum.com/showthread...hreadid=500087
|