Dataform opening on startup, and validation list in form?

[dd]

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

 

[Corey]

Place the code in the WORKBOOK OPEN event

Private Sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

Corey....

 

[Tushar Mehta]

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