Autolaunching the form box in Excel

A

Anna

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!
 
C

Chip Pearson

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
 
Top