Thread: how to Pause a VBA procedure until user presses Enter
View Single Post
  #3   Report Post  
Posted to microsoft.public.access.formscoding,microsoft.public.excel.programming
PC Datasheet PC Datasheet is offline
external usenet poster
  
Posts: 3
Default how to Pause a VBA procedure until user presses Enter
You could put a loop in the middle of your code and check for the desired
specific action to exit the loop.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

"Paul James" wrote in message
...
Is there a way to suspend execution of a VBA procedure until the user takes
a specific action like pressing the Enter key?

Thanks in advance,

Paul




Reply With QuoteReply With Quote