Refrence to Listbox in form
 

Hello, Im trying to populate a ListBox placed on form. I prefer to use
OLEObject, however I can manage to get reference to Listboxes. It works
fine when the Listbox is located in a sheet.

Set wrkSheet = ThisWorkbook.Sheets("Input")
Set OleObj = wrkSheet.OLEObjects("myListBox")

works fine, but this dosent

Set OleObj = myForm.OLEObjects("myListBox")

I basicly I want to fill the listbox and be able to count which option
that has been selected by the user.

Kind regards :)


--
rash
------------------------------------------------------------------------
rash's Profile: http://www.excelforum.com/member.php...o&userid=29765
View this thread: http://www.excelforum.com/showthread...hreadid=499776

Refrence to Listbox in form
 

Anyone? Need help on this one.


--
rash
------------------------------------------------------------------------
rash's Profile: http://www.excelforum.com/member.php...o&userid=29765
View this thread: http://www.excelforum.com/showthread...hreadid=499776

Refrence to Listbox in form
 

Dim myLB As msforms.ListBox
Set myLB = myform.Controls("MyListbox")



rash wrote:

Hello, Im trying to populate a ListBox placed on form. I prefer to use
OLEObject, however I can manage to get reference to Listboxes. It works
fine when the Listbox is located in a sheet.

Set wrkSheet = ThisWorkbook.Sheets("Input")
Set OleObj = wrkSheet.OLEObjects("myListBox")

works fine, but this dosent

Set OleObj = myForm.OLEObjects("myListBox")

I basicly I want to fill the listbox and be able to count which option
that has been selected by the user.

Kind regards :)

--
rash
------------------------------------------------------------------------
rash's Profile: http://www.excelforum.com/member.php...o&userid=29765
View this thread: http://www.excelforum.com/showthread...hreadid=499776

--

Dave Peterson