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

Place the code in the WORKBOOK OPEN event

Private Sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

Corey....
"dd" <dd.dd> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

In article <#(E-Mail Removed)>, "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