Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Why Type Mismatch error | Excel Programming | |||
Reload Listbox - type mismatch error | Excel Programming | |||
Passing User Defined Type Array to Listbox | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |