Depends what you are trying to do. If it is as simple as a single value that
is needed then an input box can work great. If however you need the user to
do something a bit more complicated such as review the results generated by
the macro or to add a bunch of stuff to multiple cells then events
programming is my preference.

Sometimes I reply in absolute terms when the best answer might be a bit of a
grey area. Thanks for pointing that out.
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Jim

Why would this method be better than a simple InputBox pause for user to enter
something then continue?


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 07:46:00 -0800, Jim Thomlinson
wrote:

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...