Looking for a way to pause a Sub until the user hits the Enter key

Hi all,

I'm looking for a way for a way to let the first part of a sub run to a certain point and then not go any further until the user hits either the Enter key or the space bar.
The sub isn't far enough along to share. It probably wouldn't make sense if you saw it.
I was hoping this would be relatively simple without the code.

If this turns out not to be easy without the code I'll try to get something together.

Thanks!

Thank you saravnepali ,

I think this is what I am looking for.
I'll probably have some kind of "Do Until" loop and then then insert your code so the user has to press the enter key before they advance.
I'll give it a try and let you know.

saravnepali,

I finally got the rest of the code working and I tried inserting a "Call" for your Sub but when I ran debug it says "Argument not optional".
Below is the code where I inserted your sub.
The "call" for the sub should be on line 59.
I would like to use your sub and get rid of the message box on lines 60 and 61.
Hopefully seeing my code will help show what I am trying to do.
Also I actually think using the "down arrow" key press might be better.
Would it be a little different code?
Thanks

Please Login or Register  to view this content.