MultiPage - Run-time error 35788:

[Zeca]

Can you please help me to build a VBA code.

I need a line of VBA code, for Excel, to change which tab the user views of a multiPage. I have ActiveX 2 controls DTPickers on page 2, Index=1 and 2 controls DTPickers on page 3, Index=2 which has to be active to load the form. Please help.

I would like to run it at initialize.
"Run-time error 35788:
an error occured in a call to the windows Date and Time Picker control"

[SamT]

Please use the Go Advanced button and on that page use the Manage Attachments button to upload the Workbook.

[Zeca]

Here is the correct answer:

Private Sub MultiPage1_Change ()

If MultiPage1.Value = 1 Then

Me.DTPickerStart = Date
Me.DTPickerEnd = Date


ElseIf MultiPage1.Value = 2 Then

Me.DTPicker1 = Date
Me.DTPicker2 = Date


End If

End Sub

[SamT]

That's not what you asked for