Input Box

C

cassy01

is it possible to create a pop-up box to type in a value ??? then whe
the user clicks "ok" that value is then pasted into "D92" ??? is thi
possible ??

thank
 
J

Jim Rech

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
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?action=getinfo&userid=780
| View this thread: http://www.excelforum.com/showthread.php?threadid=474143
|
 
J

jahoobob

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