InputBox Count and Sum Data based on Selected Date

[rylaine]

Hi there,

I was hoping to create a MsgBox or InputBox where the user can select a date (or use the date in the selected cell) with three different formulas. The InputBox might read "Select Date"-- it would be extra cool if there's some way to incorporate a calendar to click the date, but maybe that's not possible.

I want to generate all three results in one MsgBox. The formulas would be as follows, but I have no idea how to translate this into VBA code.

Total Submissions: =COUNTIF(D:D,"Date")
Total Cost Changes: =SUMIF(I:I,"Date")
Total Retail Changes: =SUMIF(K:K,"Date")

And then after seeing those values, the user could just click OK out of the box.

I'm not sure if this even makes sense but I appreciate any and all help!

Thanks!

 

[rylaine]

Ugh sorry, the date won't appear in columns I or K, but I want it to sum these values based on the date in column D!

Thank you!