from the help file:

mynum = Application.InputBox("Enter a number")
Range("a5") = mynum

--


Gary


"Alexis" wrote in message
...
Thank you! Know of a way to have the response put onto the worksheet?

"Ardus Petus" wrote:

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?