LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default position mouse cursor in msg box

Well, I thought I had seen it. Trying to automate so even the most novice
user can operate, I wrote a macro that does extensive reformatting of
imported data. I even turn off screen updating whilst it is running. When
it is finished, a message box opens, saying "Formatting Finished. Click OK".
Self explanatory, right? Wrong. Because the macro is suspending awaiting
the "click", the mouse arrow turns to an hourglass.... so the operator says
to me (after waiting I don't know how long), "But it's not done, there's
still an hourglass!".

So, is there a way to have the mouse automatically positioned 'within' the
message box-so the hourglass returns to an arrow? I know the mouse setup in
control panel can make this a default Windows feature (Snap To), but I don't
control the users of this app's pc.

Any ideas would be appreciated. Good luck!

TIA

swatsp0p
--
The older I get, the better I used to be.
 
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
cursor position MarkT Excel Discussion (Misc queries) 5 February 7th 07 01:25 PM
Cursor position saziz Excel Discussion (Misc queries) 2 August 9th 05 08:19 PM
Cursor position? Marc Excel Discussion (Misc queries) 1 March 27th 05 07:09 PM
cursor position Fan Fan Excel Programming 3 August 14th 04 01:12 AM
Position Cursor to A1 Dennis Damsgaard Excel Programming 3 June 8th 04 10:30 PM


All times are GMT +1. The time now is 02:00 AM.

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

About Us

"It's about Microsoft Excel"