Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listbox value to a form | Excel Programming | |||
vb6 form with listbox | Excel Programming | |||
listbox option in form | Excel Programming | |||
User form with a listbox | Excel Programming | |||
Listbox/Form question | Excel Programming |