+ Reply to Thread
Results 1 to 6 of 6

Userform data to start at specific cells

  1. #1
    Registered User
    Join Date
    08-22-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Userform data to start at specific cells

    Hello everyone.

    I have helper column at A, and would like to have my data to start at B2, C2, D2.
    Somehow through trial and error, I've managed to get it done.

    The problem now is, I'm only able to key-in one single data. Because, the data will be over written by the new input data.

    Perhaps anyone can rectify the code please.
    Attached Files Attached Files
    Last edited by kenjcd; 09-28-2020 at 06:05 AM.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Userform data to start at specific cells

    Get rid of your helper column and find last row of column B

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-22-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Userform data to start at specific cells

    Quote Originally Posted by torachan View Post
    Get rid of your helper column and find last row of column B

    Please Login or Register  to view this content.
    Thanks torachan, but I need the helper column to give unique id based on B2 and C2. Is it possible to accomplish this without removing the helper column?

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Userform data to start at specific cells

    When replying please do not clutter the reply with 'quote' use the quick reply box unless it is absolutely necessary to include 'quote'.
    The attached file has the on sheet formula removed as this can be better generated by the code when saving.
    Also removed surplus "|" as these confuse getting the last row.
    torachan.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-22-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Userform data to start at specific cells

    Thank you torachan!

    P/s- Next time I won't clutter my reply unless it is really necessary.
    Rep added.

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Userform data to start at specific cells

    You are welcome - thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add data from userform to specific cells on worksheet
    By Mark Dynes in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-09-2017, 11:32 AM
  2. Transferring data from userform to specific cells
    By Flexecel22! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2016, 02:11 AM
  3. Add data via userform to specific cells
    By gerardgerard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2015, 09:35 PM
  4. Enter Data from userform into cells starting from specific cell
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 04:26 PM
  5. [SOLVED] Input Userform Data into Specific Cells & Loop?
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 07:00 AM
  6. Copy data from userform to specific cells in excel workbook
    By mimet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 05:44 PM
  7. Updating cells Q1 and R1 with start and end dates selected in a userform
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2009, 07:13 AM

Tags for this Thread

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