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!
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!