Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I'm stuck... Sheet 1 contains rows of customer information. Sheet 2 contains rows of machine information (including customer number)Userform combobox #1 selection will filter machines range by customer acct number to show only that customer's machines(I got that working). Now I want to popluate a second combobox with the list of that customers machines. My Sheet 1 named range is "Customers" My Sheet 2 named range is "Equipment" Currently, without autofilter, combobox #2 shows ALL machines, for ALL customers. With combobox #1 autofiltering the records, I'm only getting the top "consecutive" records (1 - 4) showing up in the second combobox, not ALL machines for that customer. How do I specify (respecify) the combobox data source once the records are filtered? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Make Combobox act like autofilter | Excel Programming | |||
VBA question - autofilter combobox | Excel Programming | |||
ComboBox populated with data from AutoFilter | Excel Programming |