Lotus ? command

[Val Steed]

How can you do an Excel macro to pause like the old Lotus {?} ?

Val

 

[Bernard Liengme]

Visit Chip's page
http://www.cpearson.com/excel/Debug.htm
locate the heading "Break Point"
best wsihes

 

[Dave Peterson]

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

 

[Don Guillett]

If you mean to pause to enter something look in the vba help index for
Input box