Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you Tom !
This works fine to add the filtered items to the a single column combo box. But I need to fill the cbo with 3 columns (ID, foreign ID, value). The ID (first column) will be used to filter the next cbo, but I need to display a "human understandable" value in the cbo. I thought about using "cbo.list" ... but I'm stuck. More help for me ?? Kinne Dim rng As Range For Each rng In Worksheets(WorksheetFiltered).Range(RangeFiltered) .Rows If rng.EntireRow.Hidden = False Then ' magic code here End If Next rng << Kinne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting list to populate combo box | Excel Discussion (Misc queries) | |||
populate combo box | Excel Discussion (Misc queries) | |||
Populate a combo box | Excel Discussion (Misc queries) | |||
Populate List / Combo Box | Excel Discussion (Misc queries) | |||
Populate a combo Box | Excel Worksheet Functions |