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

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


.