put inputbox input into a cell
 

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.

put inputbox input into a cell
 

Range("A1").Value = Application.InputBox ("Enter anticipated per-
client fee")

put inputbox input into a cell
 

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.

put inputbox input into a cell
 

Option Explicit

Sub EnterData()
'Change sheet1 to what you want
Worksheets("Sheet1").Range("A2").Value = _
InputBox("Enter anticipated per-client fee")

End Sub

"Dave F" wrote:

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.

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.

put inputbox input into a cell
 

Oops! I forgot to include the sheet name which you probably already figured
out.

Sheets("Model Inputs").Range("A2").value = InputBox ("Enter anticipated
per-client fee")


"Dave F" wrote in message
...
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.