View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default How to force repaint of popup commandbar?

Using Excel 2003.
While a macro is in pause mode with the following loop:

Do While Go = 2
DoEvents
Loop

While this loop runs I need to activate a popup commandbar on a Userform by
pressing a button on the Userform.
The popup commandbar doesn't show properly and has to be repainted.
I have tried numerous ways to do this, including API functions, but so far
nil successful.
The best I can do is force a repaint by pressing a control on the commandbar
with SendKeys.

What would be the best way to achieve this?
Thanks for any advice.


RBS