Variable row data source for combo boxes?
 

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.

Variable row data source for combo boxes?
 

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.

Variable row data source for combo boxes?
 

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.

Variable row data source for combo boxes?
 

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.

Variable row data source for combo boxes?
 

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.