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
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
