Input Box Value Match
Posted by Troy on October 31, 2001 6:15 AM
I have an inputbox that asks for a date. I then have a list of dates and a looping statement that will extend (resize) a range to that date. The problem I am having is it is not matching in the loop statement. I believe the inputbox is a string and the list is excel formated dates. Is there a way to match the two together? Thanks.
Posted by Barrie Davidson on October 31, 2001 6:21 AM
Yes, convert the results of your inputbox to a date. Something like:
SearchDate = CDate(Format(InputBox("Enter Search Date"), "mmm-d-yyyy"))
Regards,
BarrieBarrie Davidson
Posted by Barrie Davidson on October 31, 2001 6:21 AM
Yes, convert the results of your inputbox to a date. Something like:
SearchDate = CDate(Format(InputBox("Enter Search Date"), "mmm-d-yyyy"))
Regards,
BarrieBarrie Davidson
Posted by Barrie Davidson on October 31, 2001 6:23 AM
Yes, convert the results of your inputbox to a date. Something like:
SearchDate = CDate(Format(InputBox("Enter Search Date"), "mmm-d-yyyy"))
Regards,
BarrieBarrie Davidson
