put inputbox input into a cell
Helpful, thanks.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"PCLIVE" wrote:
Maybe this:
Range("A2").value = Application.InputBox ("Enter anticipated per-client
fee")
HTH,
Paul
"Dave F" wrote in message
...
I have the following:
Option Explicit
Sub EnterData()
Dim MyString As String
Application.InputBox ("Enter anticipated per-client fee")
End Sub
Which obviously works. What I want to do is have Excel place the input
into
a speciic cell, say, A2 on the sheet "Model Inputs". Can someone point me
to
an online reference for this? Seems like this should be a simple line of
code but I can't find any hints.
Thanks,
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
|