Autolaunching the form box in Excel
 

I want to be able to open a data sheet and have the form box launch
automatically. Can anyone help me with this?
Thank you very much!

Anna,

Try something like the following:

Sub Auto_Open()
Worksheets("Sheet1").Select
Worksheets("Sheet1").ShowDataForm
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Anna" wrote in message
...
I want to be able to open a data sheet and have the form box
launch
automatically. Can anyone help me with this?
Thank you very much!