Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2000
I am trying to get AutoFilter data into a ListBox. The below code gives me an "Type mismatch" error when I try to add the Listbox Rowsource line. I read about using _FilterDatabase but could not get the right syntax. Private Sub UserForm_Initialize() Dim myVisibleRng As Range Dim myFilterRng As Range Set myFilterRange = Sheet1.Range("a1:e13000") myFilterRange.AutoFilter Field:=5, Criteria1:="18650" Set myVisibleRange = myFilterRange.SpecialCells(xlCellTypeVisible) Debug.Print myVisibleRange.Address ListBox1.RowSource = myVisibleRange '<--type mismatch End Sub Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
???Help??? Userform.Listbox.rowsource = ??? | Excel Discussion (Misc queries) | |||
RowSource in ListBox | Excel Programming | |||
ListBox Rowsource Limitation?? | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |