+ Reply to Thread
Results 1 to 5 of 5

Macro For Userform Entry that will Cut, Delete, and Paste Row

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    80

    Macro For Userform Entry that will Cut, Delete, and Paste Row

    Hi,

    Attached is a workbook that has a multi-tab Userform. The first 2 tabs work the way I need. I am having trouble with the 3rd tab (Employee Termination).

    What I want it to do:
    1.The Full Name combo box, I want to pull all the names from column C on the "Test" sheet.
    2. Once a name and date are picked, and the "Enter" button is clicked,
    a. The macro would find the name picked within the "Test" spreadsheet
    b. Copy the row from the table
    c. Paste the row in the table, 1 column over, in the "Termination" spreadsheet
    d. Add the date that was selected in the Userform into column A in the "Termination" spreadsheet
    e. Delete the empty row in the "Test" sheet

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Macro For Userform Entry that will Cut, Delete, and Paste Row

    Add this to your initialize code
    Please Login or Register  to view this content.
    In your button code, you where searching for TextBox1 when in fact you are searching for cboFullName1
    You had the wrong name for your DatePicker
    You do not require "If not Target is nothing" since the list is actually coming from the range you are searching.

    Your command button code
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-15-2016
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    80

    Re: Macro For Userform Entry that will Cut, Delete, and Paste Row

    This works! The only question I have, is I am still not getting the drop down list of names in the Full Name combo box, is there a code for this?

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Macro For Userform Entry that will Cut, Delete, and Paste Row

    I'm not sure what you mean, the list is the same as the other combobox

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Macro For Userform Entry that will Cut, Delete, and Paste Row

    This line doesn't seem to work

    Please Login or Register  to view this content.
    This does though

    Please Login or Register  to view this content.

+ 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. userform code to add or delete entry with condition
    By padreSlo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2018, 09:05 AM
  2. [SOLVED] Userform Copy Paste Delete
    By The Flying Scot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 02:30 AM
  3. [SOLVED] Userform for date entry and then copy/paste matching data to another sheet
    By nymanns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 03:22 AM
  4. Replies: 1
    Last Post: 01-17-2013, 05:27 PM
  5. Update and delete entry in Datasheet via Userform
    By Magnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 09:50 AM
  6. Macro to copy/paste info in different sheets and to delete last entry
    By barcas84 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 02-02-2012, 02:30 PM
  7. delete entry on worksheet via userform listbox
    By confused325 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2009, 12:19 PM

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