LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Display message: Processing....


Hi i know this isn't exactly what you wanted but this is a little touch
i use in my workbooks when there processing a function.

I set the status bar to my own custom processing comment.

You can also do the same with the MS Excel caption heres a bit of code
to show you how to do it

Dim status As String
Dim caption As String

status = Application.StatusBar
caption = Application.caption

Application.StatusBar = "Processing..."
Application.caption = "Processing..."

'Start Function


'End Function
Application.StatusBar = status
Application.caption = caption

Hope This Helps


--
Nigel_hough
------------------------------------------------------------------------
Nigel_hough's Profile: http://www.excelforum.com/member.php...o&userid=20623
View this thread: http://www.excelforum.com/showthread...hreadid=394248

 
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
Display a message Jarek Kujawa[_2_] Excel Worksheet Functions 0 June 3rd 08 02:44 PM
Processing...Please Wait Message Box Connie Excel Discussion (Misc queries) 3 October 19th 06 10:54 PM
processing message hans Excel Programming 5 April 26th 04 03:13 PM
How to display a message box Salman[_2_] Excel Programming 1 November 5th 03 05:01 PM
Display a busy window while processing Mohair Excel Programming 1 July 24th 03 03:39 AM


All times are GMT +1. The time now is 04:31 PM.

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"