We help IT Professionals succeed at work.

Input box prompt with only 5 possible entries

96 Views
Last Modified: 2017-04-08
Dear Experts:

Could somebody please help me with a code snippet for an Input Box:

The user is to be prompted with an inputbox that only allows 5 entries: DE or EN or ES or FR or IT. Only capital letters are allowed.

Should the user enter something other than DE, EN, ES, FR or IT, the macro is not to exit but the inputbox is to reappear.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Comment
Watch Question

Mike in ITIT System Administrator
Distinguished Expert 2017

Commented:
Can you provide a workbook example of what you have? Or at least the code that you already have?
Group Finance Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2010
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
I would myself use an UserForm but Andreas wanted an InputBox.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Pleased to help