VBA Code assistance to populate textbox with lookup sales total via date pickers

Hi All

I have a simple Userform with two date picker controls. When pressing the command button, I want to populate textbox1 with the total sales value between the dates chosen in the datepickers. I have attached my sample file.
Code I need to fix is as follows:

Please Login or Register  to view this content.

Not sure if I'm on the right track

Please Login or Register  to view this content.

Hi All

I still have no solution. Any way of getting my unsolved thread to top of page again. Am really stuck.

I've changed the code to below and now I get a result of "0". Where am I going wrong?

Please Login or Register  to view this content.

Hi All

I have now named my ranges and am using the below code. Have also attached my file. Still gets a zer reading. Anyone out there PLEASE!!!!!!!

Please Login or Register  to view this content.

Now I'm really frustrated....
My Formula works: D8 =SUMIFS(sales,date,">="&D3,date,"<="&D4) but my code does not:

Please Login or Register  to view this content.

bulina2k.... you are a genius!!!!!

Thank you...Thank you

I have been struggling for 2 days to sort this out. Couldn't find the correct vba syntax on the web to make it work.
So here, thanks to you, Is the code:

Please Login or Register  to view this content.

bulina2k....A quick question...If I were to add a column between date ans sales called Payment which contained "Cash" or "Cheque" would I amend the code as follows to give me the total of Cash sales for the dates.

Please Login or Register  to view this content.

now I get it....Lesson well learn t
It so much simpler with formulas.

Thanks again bulina2k