View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian[_17_] Ian[_17_] is offline
external usenet poster
 
Posts: 11
Default interior.colorindex causing problems


I cannot work out why the simple code below runs but then the egg
timer shows until you press the ok button.

If you comment out the first line it works fine with no egtimer.
i have tried various other ways of clearing the cells colour but
it is still the same.

i am puzzled.




Private Sub CommandButton1_Click()

Range("colA").Interior.ColorIndex = 0



MsgBox (" blah blah blah"), vbOKOnly

End Sub