Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 SP1 will not repaint the entire spreadsheet. Dan D. Excel Discussion (Misc queries) 3 November 25th 08 01:43 AM
Excel window repaint slow/stuck hmm Excel Discussion (Misc queries) 1 August 13th 08 02:44 PM
Form Repaint Problem ybazizi Excel Discussion (Misc queries) 0 January 18th 06 05:32 PM
commandbar Greg Prost[_2_] Excel Programming 2 November 21st 03 11:42 AM
commandbar hunt defj Excel Programming 2 November 17th 03 11:40 PM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"