User Input Date Loop Macro

Hi all,

Hope all is well in your macro worlds!

I am having trouble with a user input macro.

The user inputs a date for a macro to search a row for.

The dates in the row are in a dd-mmm-yy format and I am unsure why the loop is not copying my test data.

Would someone mind having a look into it for me?

I have copied the macro below and input the Excel file if willing?

Please Login or Register  to view this content.

Many thanks in advance!


Coeus.

Coeus,

Here's how I would do it, this is just one way of many...

Please Login or Register  to view this content.

Hello Coeus,

One problem with your code is you are using a reserved VBA word Month As a variable. Never redefine an existing VBA function in your code.

The other problem is you never assign the date input to the variable.

I have revised your code so it works.

Please Login or Register  to view this content.

Hello Coeus,

You're welcome.

You might look at this test for a valid entry.

Please Login or Register  to view this content.