rng.Value = Date
myVal = InputBox("Supply value please")
rng.offset(0,4).value = myVal
' the other code
rng1.offset(0,4).value = myVal
End Sub



--

HTH

RP
(remove nothere from the email address if mailing direct)


"cappuccine" wrote
in message ...

awesome.. ok, another question. Now that I have the value from the input
box, I want to repeat the code again to do the same thing on a different
sheet. I changed rng to rng1 so I don't get a duplicate error. How do I
use the value from the input box again without having to ask for it
again?


--
cappuccine
------------------------------------------------------------------------
cappuccine's Profile:
http://www.excelforum.com/member.php...o&userid=28242
View this thread: http://www.excelforum.com/showthread...hreadid=482267