limiting selections in drop down list

D

dkingston

i need to limit the available selections in a drop down list based on data in
adjacent cells.
ex: if LEFT(A1,1)="D" and LEFT(B2,1)="D" then the list contains options a, b
& c.
if LEFT(A1,1)="D" and LEFT(B2,1)="T" then list should have options d, e & f.
i am using a data validation drop down list because i am not familiar with
visual basic or in using activeX control objects. i think i may need to use a
list box.
please help and thanks in advance.
 
L

L. Howard Kittle

Just re-thought my suggested solution, you posted in Programming, you
probably want a VBA solution.

Will give it some thought, but cannot do that right now.

Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
MS Project Center-Autolink column fields 0
Difficulty with compatibility mode and Track Changes 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Data Validation List (conditional) 2
drop down list 1

Top