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

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

Richard Edwards wrote:

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

--

Dave Peterson

Hi Richard,
Take a look to Debra Web

http://www.contextures.com/xlDataVal02.html#TwoWord

If this was helpful please say yes. thank you

"Richard Edwards" wrote:

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:

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

spot on thanks vm!

"Dave Peterson" wrote in message
...
I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

Richard Edwards wrote:

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

--

Dave Peterson