MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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