I know how to create a list of "selectable items" so that my users can
select from the drop down list but how do I change the available options
based on a previous selection?

if Cell F5 = "Toronto" then the list would be Y5 to Y 30 or something like
that
iv Cell F5 = "Heaven" then the list would be Y30 to Y40

Hi

i would use data / validation for this - check out the notes at Debra
Dalgleish's website for details
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"HotRod" wrote in message
...
I know how to create a list of "selectable items" so that my users can
select from the drop down list but how do I change the available options
based on a previous selection?

if Cell F5 = "Toronto" then the list would be Y5 to Y 30 or something like
that
iv Cell F5 = "Heaven" then the list would be Y30 to Y40

HotRod, have a look here and see if this is what you want

http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"HotRod" wrote in message
...
I know how to create a list of "selectable items" so that my users can
select from the drop down list but how do I change the available options
based on a previous selection?

if Cell F5 = "Toronto" then the list would be Y5 to Y 30 or something like
that
iv Cell F5 = "Heaven" then the list would be Y30 to Y40

THANKS, this worked great I've managed to link three sub-cells from a
different worksheet. Great solution THANKS

HotRod, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"HotRod" wrote in message
...
THANKS, this worked great I've managed to link three sub-cells from a
different worksheet. Great solution THANKS

just A SIDE NOTE WHEN FOLLOWING THIS EXAMPLE PAY CLOSE ATTENTION TO THE
NAMING STRUCTURE USED AND YOUR LIST OF VALUES.

I'm currently trying to force Date validation as "mm/dd/yyyy" but no matter
what I do it just doesn't seem to work any ideas? I'm going to keep
googling..