Excel VBA to Read Range of Dates

[whcmelvin]

hi,

Could someone teach me on how to allow excel to to read a range of dates that is selected in 2 listbox using VBA?

Eg.

Listbox1 is 25/05/2015 and listbox2 is 30/05/2015.

Then the VBA code would allow excel to read the the dates from 25 to 30 May and sum the values.
Using the table below, excel will sum column 2 and return 21.
22/05/2015 10
23/05/2015 12
24/05/2015 14
25/05/2015 1
26/05/2015 2
27/05/2015 3
28/05/2015 4
29/05/2015 5
30/05/2015 6

Please Help guys

Thanks in advance!

Regards
Melvin

[MickG]

Your data in columns "A & B" Results "C1".

Please Login or Register  to view this content.

Regards Mick