ouestque
asked on
Excel VBA: Validate text is range
What VBA would I need to validate a string can also be a range?
Example:
Assume I have a sheet where the user enters text in A1. If the text can be a range like "B20" then show a message box that says, "This is a range!!"
"A1" = True: It is a range
"2-2A" = False: is not a range
Example:
Assume I have a sheet where the user enters text in A1. If the text can be a range like "B20" then show a message box that says, "This is a range!!"
"A1" = True: It is a range
"2-2A" = False: is not a range
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Both the answers resolved the original question.