Inputbox accepting desired response

  • Thread starter Thread starter Amitriumphs
  • Start date Start date
A

Amitriumphs

Hi all,

I need a macro with an input box accepting certain dates which matches
with the names of the folder present in C:\ drive in the format MMYYYY
and should give error message on any other character entered.

Any help would be appreciated.

Thanks,
Amit
 
Perhaps 2 drop down boxes. One for the month and one for the year and then
you can control what the user enters. These can be placed directly in a
worksheet cell. Look up drop down in help with a worksheet displayed. (Not in
VBA Editor)

You will then need to concatenate the two selections.

Regards,

OssieMac
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input box accepting only desired format 1
2-character limit on InputBox 4
Validation on InputBox() 5
InputBox Date Value 7
inputbox prompt 1
"Subscript out of range" -- using variable as new name of workshee 2
Code For Date Accepts Text 2
Help with macro to find matching data between two worksheets 4

Back
Top