Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Display, Edit, Add & Delete Records Via Userform

  1. #1
    Join Date
    14th January 2008
    Posts
    63

    Display, Edit, Add & Delete Records Via Userform

    Hi. I want to display on a userform the records that exist in a worksheet.

    I want also to be able to edit/delete them as well as add new ones. I want also the information to be updated in the worksheet.

    I was taking a look at some related "threads" but I am quite new in programming with excel and I am having some troubles...

    Attached there is an example of what I intend to do:

    1) When the userform is initialized I want it to display only the records filled with data in the worksheet (only the first five)
    2) The "Next" and "Previous" buttons should skip to the next and previos records respectively
    3) The "Update record" button should update the information on the worksheet.
    4) The "Delete record" button should delete the record from the worksheet (but keeping the ID number on the worksheet)
    5) The "Add new record" should add a new record (I want this new record to be saved in the next empty line in the worksheet - in this case position 6)
    6) Finally at the bottom of the userform I want to display the number of the current record as well as the total number of existing records.

    Could you kindly help with some examples of how I should write the code to initialize the Userform and for the different buttons?

    Thank you in advance!
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

  3. #3
    Join Date
    14th January 2008
    Posts
    63

    Re: Display, Edit, Add & Delete Records Via Userform

    Thank you Dave!! "J-Walk Enhanced Data Form v3" seems a great help. I will buy the VBA code and take a look!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Search & Display records on userform
    By vikrampnz in forum EXCEL HELP
    Replies: 11
    Last Post: January 14th, 2014, 00:24
  2. Add, Edit & Delete Records On Worksheet
    By MJB123 in forum EXCEL HELP
    Replies: 1
    Last Post: April 3rd, 2008, 03:16
  3. UserForm To Search, Edit, Add & Delete Data
    By leemarquis in forum EXCEL HELP
    Replies: 4
    Last Post: March 17th, 2008, 11:02
  4. Edit And Save Records In Same Row
    By ragha81 in forum EXCEL HELP
    Replies: 4
    Last Post: February 9th, 2008, 00:50
  5. Replies: 5
    Last Post: August 15th, 2004, 23:31

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
  •  
porno