+ Reply to Thread
Results 1 to 3 of 3

InputBox-ow to have a user input text in a inputbox

Hybrid View

  1. #1
    Registered User
    Join Date
    06-23-2011
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    28

    InputBox-ow to have a user input text in a inputbox

    I need to know how to have a user input text in a inputbox and append to the end of a cell.

    Example:
    Cell A1 has Customer Name: (already in the cell I need to have an input box setup so when the customer runs the micro it will prompt then to enter their name. Once their name has been enter it will append to the end of A1.)
    After input box: Cell A1 Customer Name: Joe Blow

    I'm stuck.
    Thanks ahead.
    Last edited by noodle48; 06-24-2011 at 08:19 AM. Reason: Found Solution

  2. #2
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    re: InputBox-ow to have a user input text in a inputbox

    Dim Response As String
    
    Response = InputBox("Please provide the customer name.", "Customer Name", "Customer Name")
    
    Range("A1") = Range("A1") & Response

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    re: InputBox-ow to have a user input text in a inputbox

    Something like
    Dim res As String
    
    res = InputBox("Enter something")
    Range("A1").Value = Range("A1").Value & "" & res
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1