The simplest version would be that you need the user to fill in something to
just one cell before continuing. In that case you could use a macro such as
this...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then MsgBox "Call your macro..."
End Sub

Paste this code directly into the sheet by right clicking the sheet tab and
selecting View Code. Now when cell A1 is changed this macro will fire... You
can get a lot fancier than this requiring a number of cell to be completed in
a satisfactory manner or ???
--
HTH...

Jim Thomlinson


"David Steed" wrote:

Can you show me a simple VBA code example of this?

David


"Jim Thomlinson" wrote in message
...
You don't pause a macro for input. You end the first macro when you
require
input from the user. Then based on Change Events which get fired when the
user changes values in cells you can initiate the next set of macros as
required. while that may not seem as simple as the old Lotus method it is
a
lot more powerful in what you can do.

Post back if you want some help with this...
--
HTH...

Jim Thomlinson


"David Steed" wrote:

Back Lotus 1-2-3 we could have a Macro pause with {?}. How do you pause
an
Excel macro for user input?