Input Box
 

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

Assuming this is a macro question:

Sub Ask()
Dim Resp As String
Resp = InputBox("Enter a number")
If Resp < "" Then Range("D92").Value = Resp
End Sub

--
Jim
"cassy01" wrote in
message ...
|
| 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
|

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