[RESOLVED] Passing a form object to a Sub

[DavW]

Had a problem today where I got a Type mismatch error when tying to pass a reference to Listbox object as a Sub parameter. I got round it by declaring the object as MSForms.Listbox instead of just plain Listbox.

e.g. Sub micListPre1(objListSelected As MSForms.Listbox)

The initial error must mean that there is Listbox class declared in another Library somewhere. I searched the object browser for Listbox and found the only one to be in MSForms. There are also an xlListBox and xlDialogListBoxProperties as class members within the Excel library.

Can anyone explain why I got the error in the first place? Beats me!

[WorkHorse]

There is a regular Listbox in the Excel object library. I guess it doen't show in the object browser because Excel embeds the control into a shape object.

Here's an article from MSDN on the subject: http://support.microsoft.com/default.aspx?scid=kb;en-us;181466

[DavW]

Exactly what I wanted to know!

You are indeed a Workhorse