Thread: Refrence to Listbox in form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rash rash is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote