If you combine it with a macro. Use the change event to determine whether
the data validation should be there or not.



--
Regards,
Tom Ogilvy

"Curious" wrote in message
oups.com...
Can the data validation in column B be on or off depending on the entry
in column A?



On Jan 26, 2:21 pm, Tom Ogilvy
wrote:
Look at Data=Validation

Debra Dalgleishhttp://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy



"Curious" wrote:
Please advise on what the best strategy is for this situation:

Column A is Sales Type, Column B is Client Name

If select "New Order" in Column A, I type a new client name. If select
"Renewal Order", I want to see a list of existing clients.

The purpose is to avoid any typos so that I can use code to munipulate
the data.

Thanks in advance.- Hide quoted text -- Show quoted text -