View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.