View Single Post
  #1   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

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.