+ Reply to Thread
Results 1 to 4 of 4

Amend and delete entries using userform

  1. #1
    Registered User
    Join Date
    09-07-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    19

    Amend and delete entries using userform

    I have done some searching and there are lots of other threads and websites talking about this type of thing but i just can't get any of them to work.

    I have a userform that inputs data to a sheet in my workbook. What I want to do now is build a seperate userform that will have a forward and back button. Users are allowed to scroll through each entry but not edit anything immediately. To edit there is a button called "cmdEdit" which will then let you edit and delete the entry.

    So does anyone either know a link to a working example of this type of thing- a problem i came across with others is that it doesn't allow an unknown number of rows- new entries are added daily.

    Many thanks,
    Z

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Amend and delete entries using userform

    What I want to do now is build a seperate userform that will have a forward and back button
    Here is a link to page from which you can download a sample workbook showing how to use a scrollbar to cycle through records.

    Scroll Records in a User Form

    As for editing records in the user form and updating the worksheet with the changes, you should post a sample workbook with your structure.

  3. #3
    Registered User
    Join Date
    09-07-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Amend and delete entries using userform

    Hi Palmetto,
    thanks, I checked out the link, maybe I didn't describe exactly what I want- I'm literally trying to recreate the autoform that excel creates by itself- users should never be able to see the database underneath- it's too complicated for them : )

    Thanks,
    Z

  4. #4
    Registered User
    Join Date
    09-07-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Amend and delete entries using userform

    Sorry I'm under time pressure! can anyone help??
    i solved the rest by myself but this is too much for my little brain!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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