View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Henry Markov Henry Markov is offline
external usenet poster
 
Posts: 4
Default Why null reference to ListBox?

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