dim varX as string
....
....
varX=InputBox("Type your Number")
......



Francisco Mariscal
fcomariscal at hotmail.com



-----Original Message-----
Is there a way to get a user's input while executing a
macro in Excel? I would like to have the user who is
running the macro enter a string or number, and then
store
their response in a variable declared within the macro.
.