Refrence to Listbox in form

[rash]

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]

Anyone? Need help on this one.

[Dave Peterson]

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