Excel VBA Bugs
Hi,
This is probably not the answer but perhaps... The combo
box I don't have a clue but the label maybe.
You should put a DoEvents after updating the label to
give the cpu a chance to update the label. Maybe it is so
simple, or maybe not...
Ex.
Label1.Caption = "Hello"
DoEvents
..
..
..
Hope this helped.
/Nicke
-----Original Message-----
Does anyone know where I can go to get a list of Excel
bugs in VBA? I am
having some FRUSTRATING things happen and I beleive it
is excel.
Examples:
When I acitivate a combobox on a worksheet
(ComboBox1.Activate) it
disappears! But not all of the time only sometimes.
Very strange.
Also, when I assign a value to a lable (i.e. Label1 =
ComboBox1.List(ComboBox1.ListIndex, 1)) Nothing
happens. It works 100% of
the time when I am stepping through the code with the
debugger, but it will
not work otherwise. And there is no other code that
runs after that
statement.
I am using Microsoft XP Pro with Office XP Small
Business. Any help would
be appreciated.
Thanks,
JM
.
|