Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My UserForm has a ListBox control named lbox. In the click handler of
another control on the same form I call a subroutine that has lbox as one of its parameters. I get a "Run-time error '13': Type mismatch" and when I go to debug mode and float the cursor over "lbox" in the VBA code I see "lbox = Null." However when I examine lbox in the "Locals" debug window it is well defined. What don't I understand? How can break mode debugging give different values for the same reference in different windows? Why did the error occur? HM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4) | Excel Discussion (Misc queries) | |||
'null reference' when trying to use WorksheetFunction from C# | Excel Worksheet Functions | |||
workbook and application reference set to null after the user enters something in an excel sheet | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |