Thread: Popup MsgBox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
exceluserforeman
 
Posts: n/a
Default Popup MsgBox

Create a macro that executes the Refresh All then at the end of the sub ...
assign it to a toolbar button


Sub Do_It_To_Me ()
Application.RefreshAll
msgbox"All Done!",vbexclamation,"Refesh Manager"
End sub




"jackle" wrote:

Is there a way to create a MsgBox that pops up when a Refresh All is
complete? If so, can you send code? When we pull data into worksheets from
the SQL server, it takes a while. You are constantly looking at a cursor
(curse-err!!) to see if it's complete. A pop up would be nice. Thanks in
advance.