asked on data validation masked list..and free text
Hi Experts using excel 2010
Is it possible to have data validation fromantic a named range and if the name is in the list and the end user, incorrectly types the name wrong auto correct...and also allow free text.
Is it possible to have data validation fromantic a named range and if the name is in the list and the end user, incorrectly types the name wrong auto correct...and also allow free text.
Microsoft ExcelVBA
Last Comment
Excel amusant
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for feedback...
Excel amnu...
My drop down is in column d and list in sheet 2 column f...
How do I amend vba.
Excel amnu...
My drop down is in column d and list in sheet 2 column f...
How do I amend vba.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Then you can do using vba.
Please see attached.
Dropdown-auto-corect.xlsb