Thanks for the answer.
But the problem still exists.
I use locale version (russian) and my listbox name isn't ListBox1, but with russian symbols. Besides the name contains spaces.
So, can I get control's reference with other method. May be using enumerations (or collection) of the all controls on the worksheet.
Addition: I can't see this object in dropdown list followed by sheet's name and dot, and can't see it in the dropdown list of objects (left - upper corner).
"Ron de Bruin" wrote:
Hi AsIs
This will give you the selected item
MsgBox Sheets("Sheet1").ListBox1.Value
--
Regards Ron de Bruin
http://www.rondebruin.nl
"AsIs" wrote in message ...
Hello.
I have a listbox allocated on a worksheet, not on a form.
I set input range and linked cell through properties window.
How can i access the listbox from macro? For example, access selected item in it.
Thanks