Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.ListFillRange as Variable ? in Listbox
I am trying to create a Listbox and the ListFillRange is dependent
on what is in Sheet 2 Column 1. I am sure my mistake is something simple but I cannot figure it out. Any help would be appreciated. Lance Sheets(2).Select LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row DropRange = "'Sheet2!A1:" & LastRow & "'" Sheets(1).Select ActiveSheet.ListBoxes.Add(780, 65, 125, 500).Select With Selection .ListFillRange = DropRange .LinkedCell = "" .MultiSelect = xlExtended .Display3DShading = False End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.ListFillRange as Variable ? in Listbox
DropRange = "'Sheet2'!A1:A" & LastRow
-- Regards, Tom Ogilvy wrote in message ... I am trying to create a Listbox and the ListFillRange is dependent on what is in Sheet 2 Column 1. I am sure my mistake is something simple but I cannot figure it out. Any help would be appreciated. Lance Sheets(2).Select LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row DropRange = "'Sheet2!A1:" & LastRow & "'" Sheets(1).Select ActiveSheet.ListBoxes.Add(780, 65, 125, 500).Select With Selection .ListFillRange = DropRange .LinkedCell = "" .MultiSelect = xlExtended .Display3DShading = False End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
Combo box - Listfillrange | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
ListFillRange | Excel Programming | |||
ListFillRange | Excel Programming |