I have a four-column list box with the following code in the change
event (not all columns are used in this example):
..
..
With lstbox
Range("Name1").Value = .Columns(1)
Range("Name2").Value = .Columns(0)
Range("Name3").Value = .Columns(2)
end with
..
..
If I comment out the last two range lines, it works. If I don't, a
very strange thing happens. If I place a breakpoint on the first line,
the executions breaks here as normal; but when I hit play it breaks on
this line again, and, on the third play, throws exception #381.
Meanwhile, I notice that the lstbox reference has become null.
If I dim a module-level interger as a counter (adding one to it at the
top of the event handler), it appears that the code is being called 3
times.
Am I using the Columns property incorrectly? Why is this code
executing three times?
Thanks,
Johnny
Bookmarks