Add/edit/delete records userform

**kryt0n** · 12-10-2010, 07:02 AM

Hi all,

I was wondering if any of you knew of a good tutorial for creating a simple userform which adds, edits and deletes data from a workbook.

Really I'm just after the code for how to view, edit and delete existing rows in a worksheet, but a good tutorial is probably easier to follow.

Any ideas? Would be really appreciated.

**arthurbr** · 12-10-2010, 07:10 AM

Hi

this site should get you on track. There is explanation in the code itself

**Richard Buttrey** · 12-10-2010, 07:14 AM

Hi,

Does the following from MS give you a starter for 10

http://support.microsoft.com/kb/161514

Rgds

**kryt0n** · 12-10-2010, 07:33 AM

Thanks guys, I've had a good look through those. Very very close to what I'm after.

Can you just take a look at the blank .xls I've attached so you can see what I'm after. Might make more sense that way...

**royUK** · 12-10-2010, 07:37 AM

There's another one here

**Richard Buttrey** · 12-10-2010, 07:46 AM

Hi,

User forms certainly offer a very professional look and feel, but don't ignore standard Excel Functionality. My general rule with all things Excel is to use standard Excel tools first and only resort to VBA when necessary.

For instance when I'm designing a system to add records to a database I generally design a data entry form on the worksheet, using data validation, conditional formatting, locked cells etc. as necessary and have the user enter data here. Then tucked away in a hidden row at the top of the sheet I have a row of cells that are in exactly the same order as my database. I link each of these cells to the relevant cell in the entry form, and then use a macro attached to an 'Add New Record' button which simply copies the hidden row of data and pastes it as values to the next available row on the database.

For data deletion I provide a drop down cell which uses a dynamic list range name that uses a column of data on the database. Then a macro to find the value selected in the database and a delete row instruction. Similarly for editing a record you can find the record, populate the user form and then re-enter changed data. Obviously a test is needed in this case to check whether the record already exists and decide whether to add it or replace it.

I use Excel functions to count the number of entries on a form and this allows you to determine whether the form has been fully completed and you can use this check in a macro to tell the user the form is not complete.

I find this approach much simpler and more straightforward than designing VBA userforms and adding list/combo boxes and the like.

HTH

**JCostanza** · 09-10-2018, 10:52 AM

Hello
Would you have a sample spreadsheet with add/edit records without using VBA
Thank you

**Fotis1991** · 09-10-2018, 11:49 AM

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.