Solved: Using Start and End Date via a form?

[marshybid]

Hi All,

I am trying to use a macro to filter all information based on whether specific cells are between dates set by the person running the query (start date, end date).

I want to use the MS Date Time picker, but I dont know how I call the form once I create it.

Can anyone help.

Thanks :help

Marshybid

[herzberg]

Assuming you have named the form as "Form1", you can display it by:

Sub ShowForm1()
Form1.Show
End Sub