Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation Custom
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data Validation Custom
Resolved · High Priority · Version 2007
Reply Fri 13 Aug 2010, 13:25Delegate Aquila said...
Aquila has attended:
Excel VBA Intro Intermediate course
Data Validation Custom
Hi
I am having some problems with data validation. What I am trying to do is a custime validation on a cell; ie if A1=0, user can only input x, else user can input x or y in cell B1.
have tried with data validation custom, but no luck
if you could help that it would be great!
aquila
For upcoming training course dates see: Pricing & availability
RE: Data Validation Custom
Hi Aquila, thanks for your query. It's difficult to achieve what you want using basic text entry into a cell - you'd need some code to really make it happen - but try using dependent drop downs instead, particularly if the values you want to allow the user to enter are limited. Here's a link to a walkthrough of how to achieve dependent dropdowns:
http://www.bluepecan.co.uk/excel_training_cascading_drop_down_lists_using_data_validation.html
Hope this helps,
Anthony
|