Use ListBox properties in This Workbook

[cristio26]

Thanks alot Tom!!!

Finally I discovered that it also works if you specify in which shee
the listbox is.

(ex:Sheet1). It doesn't work if you put the sheet name.

Thanks 1000 times!

Regards, Cristi

 

[Tom Ogilvy]

It depends on what you mean by Sheetname and what you mean by Sheet1. You
didn't say anywhere where the listbox is located, so I made a guess.

You can refer to a listbox using the code name

Sheet1.Listbox1.Value

or using the sheetname

Worksheets("Data").Listbox1.Value

for example, from the immediate window:

? sheet1.Name
Data
? worksheets("Data").CodeName
Sheet1
? sheet1.ListBox1.Value
Item10
? worksheets("Data").Listbox1.Value
Item10

What is acceptable can also be affected by where the code is located.