View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.