Help on date input with Inputbox

Hi all,

I was writing code to filter & copy/paste contents based on certain criteria. One of the criteria was the date in a column is equal to or earlier than the date input in the inputbox. But I couldn't get it work. - no content was copied except for header row.

The inputbox line I used was
ThresholdDate = InputBox("Enter the threshold Date in MM/DD/YYYY format")

The Autofilter line was:
Selection.Autofilter Field:=14, Criteria1:="<=ThresholdDate".

I believe other part of the code is OK because if I use a fixed date instead of "ThresholdDate", such as 12/31/2010, it copies the right content.

Thanks in advance for any help!

miaozi,

Welcome to the forum. In the future, please wrap code in code tags. As for your question:

Instead of:

Please Login or Register  to view this content.

Use this:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Hi Tigeravatar,

It did. Thanks for the quick reply!
Will read the FAQ/Forum rules more closely before future postings

Originally Posted by tigeravatar

miaozi,

Welcome to the forum. In the future, please wrap code in code tags. As for your question:

Instead of:

Please Login or Register  to view this content.

Use this:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar