Spartan300
Board Regular
- Joined
- Jul 1, 2008
- Messages
- 71
Hi,
I have a report which automatically finds the month of the year and then uses various VLOOKUPS to pull the relevant data into the report.
I have a button within the workbook so that the user can change the month displayed in cell C6 via an input box.
What I am hoping to do by way of VBA code is check that the month entered is valid, to avoid a tbale full of #NA errors.
I have tried putting data validation on the cell, but when it is entered from the input box it seems to overwrite it?
I was thinking of a VLOOKUP but I think I had some terrible code as it just crashed excel!
Thanks very much.
I have a report which automatically finds the month of the year and then uses various VLOOKUPS to pull the relevant data into the report.
I have a button within the workbook so that the user can change the month displayed in cell C6 via an input box.
What I am hoping to do by way of VBA code is check that the month entered is valid, to avoid a tbale full of #NA errors.
I have tried putting data validation on the cell, but when it is entered from the input box it seems to overwrite it?
I was thinking of a VLOOKUP but I think I had some terrible code as it just crashed excel!
Thanks very much.