+ Reply to Thread
Results 1 to 3 of 3

Userform button to delete record

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Userform button to delete record

    Hello Everyone,

    In the attached file the i made delete button in userform to delete the entire selected row. i used the following code , but it doesnt work

    Please Login or Register  to view this content.
    DE0 value id an identifier
    Attached Files Attached Files
    Last edited by Mahmoudelnemr; 10-06-2019 at 12:50 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Userform button to delete record

    Hello Mahmoud,

    The worksheet "DT" is protected. You must remove the protection before you can delete the row. Afterward, you can protect the worksheet.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: Userform button to delete record

    Thanks Leith Ross

+ 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. delete record in excel using userform
    By tussiam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2019, 03:39 AM
  2. [SOLVED] Creating Search and Delete Button to delete record
    By Mnet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2017, 07:48 PM
  3. [SOLVED] UserForm in Excel- command button to save record
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2013, 11:50 AM
  4. Delete record from listbox via Userform
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-19-2011, 03:31 AM
  5. [SOLVED] Adding a Next Record button to UserForm
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 11:30 AM

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