Thread: 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

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.

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

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