+ Reply to Thread
Results 1 to 4 of 4

InputBox to input data for each row

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    InputBox to input data for each row

    Hi There,

    I am looking to have a spreadsheet that once data is added to a cell it will pop asking for data for the 3 cells.

    Example:
    C3 insert data "1234"
    Pop up asking to enter a date - Fills the data from input box to cell C4
    Pop up asking to enter name - Fills the data from input box to cell C5
    Pop up asking to enter Order ID - Fills in data from input box in C1

    C4 insert data "9854"
    Pop up asking to enter a date - Fills the data from input box to cell C4
    Pop up asking to enter name - Fills the data from input box to cell C5
    Pop up asking to enter Order ID - Fills in data from input box in C1

    And so on.

    I can get the input boxes but cant seem figure out how to have the data for the single rows.

    If you can help that would be awesome.

    Thanks Shif.

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: InputBox to input data for each row

    You could use something like this:

    Please Login or Register  to view this content.
    However, I have to question overwriting the data in C4 with the code when you have to put 9854 into C4 to trigger the code. Did you mean to do that?
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Registered User
    Join Date
    10-11-2011
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: InputBox to input data for each row

    Quote Originally Posted by davegugg View Post
    You could use something like this:

    Please Login or Register  to view this content.
    However, I have to question overwriting the data in C4 with the code when you have to put 9854 into C4 to trigger the code. Did you mean to do that?
    I did not mean to do this, "guess I was in a rush to get out to lunch".

    It would of been C3, D3, E3... and so on. Also I would like to have the inset data that can be anything activate the input boxes so 1234 can be "anything entered in cell"
    Example:
    C3 insert data "1234"
    Pop up asking to enter a date - Fills the data from input box to cell C4
    Pop up asking to enter name - Fills the data from input box to cell C5
    Pop up asking to enter Order ID - Fills in data from input box in C1

    D3 insert data "9854"
    Pop up asking to enter a date - Fills the data from input box to cell D4
    Pop up asking to enter name - Fills the data from input box to cell D5
    Pop up asking to enter Order ID - Fills in data from input box in D1

    Sorry for the improper information at first..
    Last edited by Shifcane; 10-25-2011 at 03:00 PM.

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

    Re: InputBox to input data for each row

    Seems a pointless exercise - it would be quicker to just enter the data into the cells
    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