Variable row data source for combo boxes?

[AndyRoo]

I have a user form that requires 2 choices to be made, currently using combo
boxes for both.
I would like to make the choices 'smarter' though such that the choice
selected in the first combo box drives the choices available in the second
combo box.
I have 9 possible choices for the first combo box, each each of which should
have 3 to 9 possible choices listed in the second combo box, these choices
are in 9 separate rows in my data sheet.
So far I haven't figured out how to do this so the second combo box has been
set to refer to a 10th row source in which I have copied all the possible
answers for all the choices that could be made in the first box.
Any suggestions for a way to achieve this, I am not a slave to combo boxes
if there is a better option. I need it to be flexible so the user can change
their mind about the both choices before finally moving on though.

[Toppers]

Look at Data Validation - creating dependent lists:

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

HTH

"AndyRoo" wrote:

> I have a user form that requires 2 choices to be made, currently using combo
> boxes for both.
> I would like to make the choices 'smarter' though such that the choice
> selected in the first combo box drives the choices available in the second
> combo box.
> I have 9 possible choices for the first combo box, each each of which should
> have 3 to 9 possible choices listed in the second combo box, these choices
> are in 9 separate rows in my data sheet.
> So far I haven't figured out how to do this so the second combo box has been
> set to refer to a 10th row source in which I have copied all the possible
> answers for all the choices that could be made in the first box.
> Any suggestions for a way to achieve this, I am not a slave to combo boxes
> if there is a better option. I need it to be flexible so the user can change
> their mind about the both choices before finally moving on though.
>

[AndyRoo]

Helpful reference thanks! I am still struggling to get it to do what I want
as slickly as I'd like though.
Do you know whether there is code instruction I could write to say 'when
user selects item from combo box 1 then do x, y & z' I know the x,y&z I want
it to do, I just don't know the code to prompt it to go and do it.
I hope that isn't clear as mud!

"Toppers" wrote:

> Look at Data Validation - creating dependent lists:
>
> http://www.contextures.com/xlDataVal02.html
>
> HTH
>
> "AndyRoo" wrote:
>
> > I have a user form that requires 2 choices to be made, currently using combo
> > boxes for both.
> > I would like to make the choices 'smarter' though such that the choice
> > selected in the first combo box drives the choices available in the second
> > combo box.
> > I have 9 possible choices for the first combo box, each each of which should
> > have 3 to 9 possible choices listed in the second combo box, these choices
> > are in 9 separate rows in my data sheet.
> > So far I haven't figured out how to do this so the second combo box has been
> > set to refer to a 10th row source in which I have copied all the possible
> > answers for all the choices that could be made in the first box.
> > Any suggestions for a way to achieve this, I am not a slave to combo boxes
> > if there is a better option. I need it to be flexible so the user can change
> > their mind about the both choices before finally moving on though.
> >

[AndyRoo]

Scratch the follow on, I have found the answer, it was in the reference you
gave me! Thanks very much!

"AndyRoo" wrote:

> Helpful reference thanks! I am still struggling to get it to do what I want
> as slickly as I'd like though.
> Do you know whether there is code instruction I could write to say 'when
> user selects item from combo box 1 then do x, y & z' I know the x,y&z I want
> it to do, I just don't know the code to prompt it to go and do it.
> I hope that isn't clear as mud!
>
> "Toppers" wrote:
>
> > Look at Data Validation - creating dependent lists:
> >
> > http://www.contextures.com/xlDataVal02.html
> >
> > HTH
> >
> > "AndyRoo" wrote:
> >
> > > I have a user form that requires 2 choices to be made, currently using combo
> > > boxes for both.
> > > I would like to make the choices 'smarter' though such that the choice
> > > selected in the first combo box drives the choices available in the second
> > > combo box.
> > > I have 9 possible choices for the first combo box, each each of which should
> > > have 3 to 9 possible choices listed in the second combo box, these choices
> > > are in 9 separate rows in my data sheet.
> > > So far I haven't figured out how to do this so the second combo box has been
> > > set to refer to a 10th row source in which I have copied all the possible
> > > answers for all the choices that could be made in the first box.
> > > Any suggestions for a way to achieve this, I am not a slave to combo boxes
> > > if there is a better option. I need it to be flexible so the user can change
> > > their mind about the both choices before finally moving on though.
> > >

[Toppers]

Glad you have solved your problem .. and thanks for the feedback.

"AndyRoo" wrote:

> Scratch the follow on, I have found the answer, it was in the reference you
> gave me! Thanks very much!
>
> "AndyRoo" wrote:
>
> > Helpful reference thanks! I am still struggling to get it to do what I want
> > as slickly as I'd like though.
> > Do you know whether there is code instruction I could write to say 'when
> > user selects item from combo box 1 then do x, y & z' I know the x,y&z I want
> > it to do, I just don't know the code to prompt it to go and do it.
> > I hope that isn't clear as mud!
> >
> > "Toppers" wrote:
> >
> > > Look at Data Validation - creating dependent lists:
> > >
> > > http://www.contextures.com/xlDataVal02.html
> > >
> > > HTH
> > >
> > > "AndyRoo" wrote:
> > >
> > > > I have a user form that requires 2 choices to be made, currently using combo
> > > > boxes for both.
> > > > I would like to make the choices 'smarter' though such that the choice
> > > > selected in the first combo box drives the choices available in the second
> > > > combo box.
> > > > I have 9 possible choices for the first combo box, each each of which should
> > > > have 3 to 9 possible choices listed in the second combo box, these choices
> > > > are in 9 separate rows in my data sheet.
> > > > So far I haven't figured out how to do this so the second combo box has been
> > > > set to refer to a 10th row source in which I have copied all the possible
> > > > answers for all the choices that could be made in the first box.
> > > > Any suggestions for a way to achieve this, I am not a slave to combo boxes
> > > > if there is a better option. I need it to be flexible so the user can change
> > > > their mind about the both choices before finally moving on though.
> > > >