Application.Inputbox, look it up in VBA help as there are various type
options.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...

-----Original Message-----
Hi,

is there a way to pause the macro, allow the user to
change some values in a worksheet and resume the macro
again?

thanks

Hasan


.