validation list or combo box dependant on cell value
 

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

validation list or combo box dependant on cell value
 

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

validation list or combo box dependant on cell value
 

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

validation list or combo box dependant on cell value
 

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

validation list or combo box dependant on cell value
 

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