drop down box activated and filled by another's action

Hi All,

I sort of new to VBA so please bear with me...

I need a drop down box with yes/no as the choices - that bits easy - and when "yes" is picked I need another drop down to be filled (that too seems OK using something like =INDIRECT(VLOOKUP(A2,namelookup,2,0)) in the list, source of the Data>Validation menu choice).

But this setup isn't perfect - the picking of "yes" (from the first drop down) causing the filling of the second drop-down doesn't automatically display the second ddb and make it become active (the user needs to know its there).

I have found some code that sounds appropriate, but have no idea where this should be installed or what it should do...

If Cells(1,1).Value = "Yes" then
  'do what you want if they chose yes
else
  'do what you want if they chose no
end if

bbw. the reference to Cells sounds strangely cryptic - I assume this is instead of A1 excel cell references.

Any help/suggestions would be greatly appreciated.

Thanks, Roy

roytom,

welcome to the forum. Please take a look at the forum rules, especially with regards to code tags when posting code.

I'll add the tags for you this time, but expect you to use them from now on.

With regards to your question, you can use dependent data validation as outlined here: http://www.contextures.com/xlDataVal02.html

I don't quite understand your statement

the picking of "yes" (from the first drop down) causing the filling of the second drop-down doesn't automatically display the second ddb and make it become active (the user needs to know its there).

You may want to post a sample workbook with dummy data that illustrates your issue.

PS: the Cells() syntax is: Cells(rowIndex, columnIndex)
so, Cells(1, 1) is A1 and Cells(3, 5) is ....













































E3

cheers