+ Reply to Thread
Results 1 to 3 of 3

UserForm Cell Population into Newly Inserted Row

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    UserForm Cell Population into Newly Inserted Row

    Please see attached file. Beginner here! I am trying to create a filterable To-Do List.
    My goal is to enter each item with a userform, which I have created and pops up upon clicking the "Insert" textbox.
    From there I am lost.
    I need help with making the following macros happen:
    1) I would like to insert the new item in a row at top of existing info, below the headers, with the populated information from the userform when you click the "Add" Commandbutton on the Userform.
    2) I want to make sure any filtering is reset whenever a new item is entered so the list reverts to original appearance.

    Any help is much appreciated!!! (If possible, please add notes at each code line so I can continue to learn & understand whats going on... Thanks!)

    Thanks,

    -Mr_Ekid

    To Do List.xlsm
    Last edited by Mr_Ekid; 02-28-2014 at 02:23 PM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: UserForm Cell Population into Newly Inserted Row

    Try it like this....
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: UserForm Cell Population into Newly Inserted Row

    Exactly what I was looking for.

    Thanks so much!

+ 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. Add Default Value from Dropdown of Newly Inserted Row
    By Jasonsan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2013, 02:08 PM
  2. [SOLVED] How to use variables in newly-inserted columns?
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2013, 07:45 AM
  3. Replies: 6
    Last Post: 06-21-2013, 10:45 PM
  4. vba to insert new row AND highlight NEWLY INSERTED ROW
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 11:56 PM
  5. Replies: 1
    Last Post: 11-11-2005, 02:50 PM

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