View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kleev Kleev is offline
external usenet poster
 
Posts: 34
Default Passing Userform Listbox to sub causes type-mismatch error

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.