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