LinkBack URL
About LinkBacks
Hi,
I want to protect users from manually inputting information on a cell but allow them to use a drop down list to select information.
Thank you
Hi,
I want to protect users from manually inputting information on a cell but allow them to use a drop down list to select information.
Thank you
If you will create a drop down user may become restrict to enter manual data except drop down choosing data, If there is another thing you want to do please explain bit clear
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
When you set up a data validation list (Data ribbon) Excel automatically sets it such that only items on that list can be entered. It will throw up an error message if you try to add anything that isn't.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
hi Ali,
You right, but should they type anything that is in the list excel will allow.
my challenge is that I want the data exactly as in the list e.g if I have pH in the list and they type ph excel will allow.
in short the information is later imported to a software that is case sensitive for further analysis.
regards
In that case, you might need to use VBA.
Have a look at this link https://answers.microsoft.com/en-us/...0-1ea09c1ec1e8
Hope this would help you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks