| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
| Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
| filling combo boxes from single outer source | Excel Discussion (Misc queries) | |||
| Combo Boxes for data entry | Excel Worksheet Functions | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
Linear Mode
