+ Reply to Thread
Results 1 to 2 of 2

Edit/Delete data rows using VBA / Userform

  1. #1
    Registered User
    Join Date
    09-30-2015
    Location
    United States
    MS-Off Ver
    2007
    Posts
    37

    Edit/Delete data rows using VBA / Userform

    So...I have had some time to think this one through a bit.

    Currently, when a user adds data (using the Add Line Item button), the rows will populate with an auto-generated LINE number along with the information from the form. I've attached a sample form with LINE 1 filled in.

    Is there a method of making that LINE number a "hyperlink" to open a form (pre-populated with that rows information) - and on that form have Cancel, Delete, and Save buttons?

    Then, if I change data in the form and select Save. I want the new data to overwrite the current data for this particular row.

    If I select the Delete button, this row will be deleted from the spreadsheet and any row below the deleted row will move up?

    If I select Cancel, the form will close and nothing will happen.

    I should note: I do not know how to code. I've been able to create this form by asking lots of questions and getting great answers on these Forums. If you have the time and desire to spell things out clearly for me...or even just put the code in there for me.....well...you know how much frustration you'd be saving me!
    F-0068 04OCT2015_H.xlsm

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Edit/Delete data rows using VBA / Userform

    Hi @BigPaulMc

    Check the attached file

    I've modified a bit your usrform
    added an "Edit" button on it

    so when you click on the "insert line" the "edit" button is dimmed
    but when you click on any filled cell in range "C26:C45" the form comes up with the "add" button dimmed
    and all of that row values loades to the form
    Attached Files Attached Files
    Barriers are there for those who don't want to dream

+ 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/edit/delete records userform
    By kryt0n in forum Excel General
    Replies: 7
    Last Post: 09-10-2018, 11:49 AM
  2. UserForm : i need a userform to add data, delete data, edit data
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 01:59 AM
  3. Userform for search, edit, change and delete
    By delizoki66 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2013, 01:07 AM
  4. [SOLVED] UserForm for Edit or delete an order
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2013, 02:06 PM
  5. Userform Buttons to Delete or Edit existing data
    By rach3lmclark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2013, 11:53 AM
  6. [SOLVED] Userform Add, Edit, Delete
    By jonjmortimer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2012, 08:59 PM
  7. UserForm selected data; to edit multiple worksheets(& specific rows)
    By anonfish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2010, 11:43 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