Place this in a macro:
myNum = Application.InputBox("Enter a number")
Range("d72").Value = myNum

cassy01 Wrote:
is it possible to create a pop-up box to type in a value ??? then when
the user clicks "ok" that value is then pasted into "D92" ??? is this
possible ??

thanks


--
cassy01
------------------------------------------------------------------------
cassy01's Profile:
http://www.excelforum.com/member.php...nfo&userid=780
View this thread:
http://www.excelforum.com/showthread...hreadid=474143


--
jahoobob