validation list or combo box dependant on cell value

  • Thread starter Thread starter Richard Edwards
  • Start date Start date
R

Richard Edwards

Am i able to determine the values shown in either a validation list or combo
box being dependant on a value in another cell?

ie: Cell A1 = BOB then validation or combo box would then base it's list
from the named range (or whatever the solution may be) based on Bob.
if i was to change A1 to ROY then it would also change the underlying list?

I have tried everything that i think SHOULD work but that it pretty
limited...

thanks in advance

rich
 
Make a Google search with "dynamic validation list"! You'll find many
solutions and tutorials!

Regards,
Stefi

„Richard Edwards†ezt írta:
 
Back
Top