MrExcel Publishing
Your One Stop for Excel Tips & Solutions

listbox on userform

Posted by xye on February 11, 2002 10:24 AM


i was trying to do something like that 9excel 2000)
userform module

i putted listbox on form
and then added code like this :

dim lb as Object
set lb = ListBox1

then i was trying to make procedure

sub test( lbox as Object)
end Sub

when i was trying to call that function by typing
i get object required error

what am i doing wrong ?
please help

Posted by Juan Pablo G. on February 11, 2002 11:51 AM

In an UserForm i put a Listbox, then tried this simple test

Private Sub UserForm_Click()
Dim Lb As MSForms.ListBox
Dim Lb1 As ListBox
Set Lb = ListBox1
MsgBox TypeName(Lb)

Set Lb1 = ListBox1
MsgBox TypeName(Lb1)
End Sub

As you SHOULD see, the first line should be Ok, and the second one causes an error. Why ? well, Excel has two types of listboxes, one of its own, the ListBox that you see in the Forms toolbar, which is "unique" to Excel, and the Control ListBox, which is a Form, available to all Office programs.

Hope that helps

Juan Pablo G.