I don't remember the old Lotus macros, but didn't that pause allow the user to
do something and then continue?
If yes, then there are a couple of things you may want to use in VBA.
If you want to get something back from the user:
dim myStr as string
mystr = Inputbox(Prompt:="enter a string")
dim resp as long
resp = msgbox(Prompt:="Want to continue?",buttons:=vbyesno)
if resp = vbno then
exit sub 'quit
end if
or if you want to just give them a message:
msgbox "The process is about half done"
or not pausing, but just showing some text in the statusbar:
application.statusbar = "howdy!"
....
application.statusbar = false 'give it back to excel
