View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dd dd is offline
external usenet poster
 
Posts: 95
Default 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