View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel_hough[_3_] Nigel_hough[_3_] is offline
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