Passing Userform Listbox to sub causes type-mismatch error
Sub LBClear(lb As MSForms.ListBox)
lb.Clear
End Sub
Excel also has a listbox object which takes precedence - so you need to
qualify
--
Regards,
Tom Ogilvy
"Kleev" wrote in message
...
I have a simple sub I created to verify this problem. When I send a
Listbox
from a userform as such: LBClear ListPuppyMo1, I get a type-mismatch
error.
Sub follows:
Sub LBClear(lb As ListBox)
lb.Clear
End Sub
When I debug the program and enter typename(listpuppymo1) it states that
it
is a listbox. It may be that they are 2 different types of listboxes, but
if
so, I cannot figure out how to specify that I want the lb parameter to be
a
userform listbox.
|