+ Reply to Thread
Results 1 to 3 of 3

input box to insert values under last line of data

  1. #1
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    input box to insert values under last line of data

    im trying to have a popup box to add data in a column. but i want it to add the data under the last row that has data.

    example

    Date...........quantity A.............quantity B
    6/12...............1
    6/13..........................................2

    (dots used to show columns)

    i want to run a macro that will bring up a popup box to add data. i want that data to go under the last row with data.

    I only know a little about macros but i started a code to add input

    Please Login or Register  to view this content.
    i know i need to put something in the range part but i don't know how to make the range put the value under the last row of data in column a for the date.
    Also what do i add to the code to have the same input box and have another entry for the change in quantity A and another for change in quantity B all added in the same row?

    using the example above, i would want to insert data under the last row (6/13..............................2) and have it add a date under column A, and quantity under columns B and C

    thanks for any help
    JED
    Last edited by jed38; 08-15-2012 at 04:30 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: input box to insert values under last line of data

    Hello there,

    Attached is an example workbook that includes a command button on worksheet Sheet1. The command button will bring up a userform, enter information here and then click Add.

    Let me know if this is what you were looking for.

    Thanks!
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: input box to insert values under last line of data

    thank you so much rvasquez this is exactly what i wanted
    ill figure out how to add a cancel button unless your kinda enough to do that
    your a life saver

+ 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