Posted to microsoft.public.excel.misc
|
|
Enter free form text into box upon opening excel
Thanks -
I appreciate the help!
dan
"mrice" wrote:
There are a couple of ways to trigger the appearance of a userform on
start up.
1 call the macro Auto_open and locate it on a module sheet
2 Call the macro Workbook_open and place it on the ThisWorkbook tab in
the VBA editor
The code would be something like
Sub Auto_open()
UserForm1.Show
End Sub
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=564289
|