Thread: Excel VBA Bugs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nicke[_4_] Nicke[_4_] is offline
external usenet poster
 
Posts: 7
Default 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


.