Pause macro for input then resume?

[drdumont]

As powerful as EXCEL is, I am hard put to believe that there is no way to have a macro pause, wait for user input (ended with a carriage return [the ENTER key for you young pups]), then continue the macro.
Simply put, I want the macro to select a cell, wait for input and an [ENTER] then continue the macro from that point. It was so simple in Lotus and Quattro by the use of a (?) in the macro. I've seen many responses elsewhere that it is not possible, but it seems to me to be a very basic function which should not have been left out.
Is there really no way to do this in an Excel macro without seemingly hundreds of lines of code?
Thanks for any input-
-- Doc

 

[Michael M]

what about using an InputBox to insert the user input ?

 

[mikerickson]

This will take input from an InputBox. Code execution will wait until the user enters data into the Box

Dim uiValue as String

Rem some code 

Application.Goto ThisWorkbook.Sheets("Sheet1").Range("C10")

uiValue = Application.InputBox("Enter Something", type:=2)

If uiValue = "False" Then Exit Sub: Rem cancel pressed

ThisWorkbook.Sheets("Sheet1").Range("C10").Value = uiValue

Rem continue on

 

[ttray33y]

As powerful as EXCEL is, I am hard put to believe that there is no way to have a macro pause, wait for user input (ended with a carriage return [the ENTER key for you young pups]), then continue the macro.
Simply put, I want the macro to select a cell, wait for input and an [ENTER] then continue the macro from that point. It was so simple in Lotus and Quattro by the use of a (?) in the macro. I've seen many responses elsewhere that it is not possible, but it seems to me to be a very basic function which should not have been left out.
Is there really no way to do this in an Excel macro without seemingly hundreds of lines of code?
Thanks for any input-
-- Doc

how about the inputbox method ?

Application.InputBox(Prompt:=_
"blah blah blah"), _
Title:="Blah blah dialog box", Type:=8)

 

[drdumont]

Thanks to both of you for the speedy reply. I will play with it and see if I can figure it out.

Again,
Thanks!