Dataform opening on startup, and validation list in form?
 

Is there a way to have the DataForm command activate when the file is opened
? I tried the following worksheet event, but nothing happens:

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Also, is there a way to attach validation lists to the form's textboxes so
that users can select the required data?

Regards
D Dawson

Dataform opening on startup, and validation list in form?
 

Place the code in the WORKBOOK OPEN event

Private Sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

Corey....
"dd" <dd.dd wrote in message
...
Is there a way to have the DataForm command activate when the file is
opened
? I tried the following worksheet event, but nothing happens:

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Also, is there a way to attach validation lists to the form's textboxes so
that users can select the required data?

Regards
D Dawson

Dataform opening on startup, and validation list in form?
 

In article , "dd" <dd.dd says...
Is there a way to have the DataForm command activate when the file is opened
? I tried the following worksheet event, but nothing happens:

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Also, is there a way to attach validation lists to the form's textboxes so
that users can select the required data?

Regards
D Dawson



You already have a response to your first question.

As far as the 2nd goes, no, the data form supports nothing beyond the bare
basics.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions