Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Userform Listbox to sub causes type-mismatch error
Hi,
Use Sub LBClear(lb As MSForms.ListBox) instead. There are several types of listboxes, the one on the Forms toolbars that is intrinsic (i believe) to excel, and the one from the Control Toolbox toolbar from the MSForms library. So, in the parameter list of the Sub, without telling from which library the variable is from, vba assumes the lisbox intrinsic to excel... the wrong one in your case. -- Regards, Sébastien <http://www.ondemandanalysis.com "Kleev" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |