Auto Fill date parameters VBA

[jamy123]

Hi was wondering if anyone case help, i have a button which when you click it prompts you to put in a from date and too date, which then in turn fills in this part of a OBDC query('" & sFrom & "' and '" & sTo & "' " & _"). But i no longer want to have to type the date in i would like it to auto fill from predefined cells in the worksheet (From: D3 to D4).

My code before hand worked great witht he popup box: In attached (wont let me post with it in?)


The query will run but returns no results, debugging it looking for a date of: 1899/12/29

Could anyone offer any assistance please?

Thanks in advance

[KOKOSEK]

Check this part:

Please Login or Register  to view this content.

try like this:

Please Login or Register  to view this content.