Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate combobox with visable rows only
I have a combobox where the rowsource property refers to a range on a worksheet
i.e. Sheet1!A: However, I am using Autofilter to reduce this list. I would like only the visable rows on Sheet1 to populate the rowsource property but it currently includes the hidden ones Any ideas Max |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate combobox with visable rows only
You would have to remove the rowsource property and load the box with code
using additem. An alternative would be to copy the filtered data to another location and point the rowsource at that. there really is no reason to point the whole column. In the initialize event Private Sub Userform_Initialize() With Worksheets("Sheet1") set rng = .Range(.Cells(1,1),.Cells(1,1).End(xldown)) End With ComboBox1.RowSource = rng.Address(external:=True) End sub -- Regards, Tom Ogilvy "max" wrote in message ... I have a combobox where the rowsource property refers to a range on a worksheet. i.e. Sheet1!A:A However, I am using Autofilter to reduce this list. I would like only the visable rows on Sheet1 to populate the rowsource property but it currently includes the hidden ones. Any ideas? Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make the autosum refer to visable rows / filter? | Excel Worksheet Functions | |||
how to get Excel 07 combobox to populate from MS Access table? | Excel Discussion (Misc queries) | |||
Combobox list - only with rows that fit the criteria | Excel Discussion (Misc queries) | |||
How do i populate a text box according to selection in combobox? | Excel Worksheet Functions | |||
Having data populate text boxes based on Combobox Value | Excel Programming |