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

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