| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can one combo box control the data in a different combo box
I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box? What I would like to have set up is one box that has a list of my regions and when a user selects one region the next combo box, for store#, will only display the stores in that region. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can one combo box control the data in a different combo box
i hope you see this.If you mean a forms toolbar combo the answer is yes,i use
a vookup formula to populate the combo box(es) -- paul remove nospam for email addy! "MarkM" wrote: I though I saw a post on this some time ago but cannot find it. Is it possible to have one combo box control the input range for another combo box? What I would like to have set up is one box that has a list of my regions and when a user selects one region the next combo box, for store#, will only display the stores in that region. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can one combo box control the data in a different combo box
I am using a forms combo box. I do not understand how you get the second box
to use the results from a vlookup. "paul" wrote: i hope you see this.If you mean a forms toolbar combo the answer is yes,i use a vookup formula to populate the combo box(es) -- paul remove nospam for email addy! "MarkM" wrote: I though I saw a post on this some time ago but cannot find it. Is it possible to have one combo box control the input range for another combo box? What I would like to have set up is one box that has a list of my regions and when a user selects one region the next combo box, for store#, will only display the stores in that region. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can one combo box control the data in a different combo box
http://www.xldynamic.com/source/xld.Dropdowns.html -- DCSwearingen Getting old, but love computers. ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=569917 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can one combo box control the data in a different combo box
Mark
Haveyou figured this out as yet? Have a similar issue. "MarkM" wrote: Paul, I sent you an email. "paul" wrote: what is your email address i will send you an example -- paul remove nospam for email addy! "MarkM" wrote: I am using a forms combo box. I do not understand how you get the second box to use the results from a vlookup. "paul" wrote: i hope you see this.If you mean a forms toolbar combo the answer is yes,i use a vookup formula to populate the combo box(es) -- paul remove nospam for email addy! "MarkM" wrote: I though I saw a post on this some time ago but cannot find it. Is it possible to have one combo box control the input range for another combo box? What I would like to have set up is one box that has a list of my regions and when a user selects one region the next combo box, for store#, will only display the stores in that region. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Combo box with data to use as hyperlinks | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| extract data from combo box n use it in SQL | Excel Discussion (Misc queries) | |||
Linear Mode
