+ Reply to Thread
Results 1 to 4 of 4

Filling in values into the last row of data

  1. #1
    Registered User
    Join Date
    12-19-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    11

    Filling in values into the last row of data

    Hi guys,

    i have a user form that takes in 3 values through text box's.. does anyone know of a way that a macro can run when i click submit so it fills the 3 values into columns H, I and P in the last row of data?

    desperate for a solution, thanks in advance

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Brain teaser: Filling in values into the last row of data

    Way over my head.....

    Maybe if you use this forum's search function....



  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Brain teaser: Filling in values into the last row of data

    Its possible. Attach your sample file and we can assist you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Brain teaser: Filling in values into the last row of data

    This will put values in the row immediatly below the last filled cell in col H.
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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