LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
referencing inputbox input to worksheet SDH Excel Programming 1 April 18th 07 08:19 AM
Check on the input in an inputbox Tempy Excel Programming 5 May 17th 05 02:01 PM
Numerical Input via an inputbox method Tom Ogilvy Excel Programming 0 August 16th 04 07:33 PM
Numerical Input via an inputbox method Bob Phillips[_6_] Excel Programming 0 August 16th 04 07:30 PM
Check on the input in an inputbox Les Stout Excel Programming 2 January 14th 04 03:18 PM


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"