Excel 365 VBA: Filter sql query with form

Hi everyone,

I have a sql query in my vba code.
My data connection uses ado.
The query result will be stored into my table.

Now I want to use a form in order to set the date range and a name filter where I can chose a name or if not all names will be selected, see attached screenshot.
Field 1 = start date, field 2 = end date and field 3 a list filter.


form.jpg


Let's say we have a sql query like:

Please Login or Register  to view this content.

I already created the form but how to use the bind variable to my sql code? And how call this form?
First the form has to be called that the user can insert a date or select a name.


Thanks for any advice or example.

something like:

Please Login or Register  to view this content.