Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to a listbox
Hello,
I have a listbox on a worksheet. I know how to refer to it from the worksheet module that it's in: Me.listTasks.ListIndex = -1 but how would I refer to it from another module? Thanks. Geof. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to a listbox
? worksheets("Sheet1").Listbox1.Value
DDDD as an example. -- Regards, Tom Oglvy "Geof Wyght" wrote in message ... Hello, I have a listbox on a worksheet. I know how to refer to it from the worksheet module that it's in: Me.listTasks.ListIndex = -1 but how would I refer to it from another module? Thanks. Geof. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to a listbox
Yes, that helped, thanks.
For some reason, this did not work: wksDash.listTasks.ListIndex = -1 whe Set wksDash = ThisWorkbook.Worksheets("Dashboard") But this did: ThisWorkbook.Worksheets("Dashboard").listTasks.Lis tIndex = -1 Geof. -----Original Message----- ? worksheets("Sheet1").Listbox1.Value DDDD as an example. -- Regards, Tom Oglvy "Geof Wyght" wrote in message ... Hello, I have a listbox on a worksheet. I know how to refer to it from the worksheet module that it's in: Me.listTasks.ListIndex = -1 but how would I refer to it from another module? Thanks. Geof. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |