Excel VBA Bugs

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

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
 
Back
Top