Search,Edit,Add,Delete userform

[Ashleytaylor1702]

Hello,

I am trying to design a user form using a sample workbook I found on the forum to Search,Edit,Add,Delete a table within a worksheet.

The table is called table5 and has 9 columns

I've modified the code however I'm getting 'Subscript ou of range' error

Please Login or Register  to view this content.

Can anyone help?
Thanks

[Ochimus]

Add NEW entry to Database:

Please Login or Register  to view this content.

FIND an existing entry and upload data to User Form, assuming Database is Sheet 1:

Please Login or Register  to view this content.

UPDATE the Database record after changing something in the User Form:

Please Login or Register  to view this content.

Hope this helps

Ochimus

[Ashleytaylor1702]

Add NEW entry to Database:

Please Login or Register  to view this content.

FIND an existing entry and upload data to User Form, assuming Database is Sheet 1:

Please Login or Register  to view this content.

UPDATE the Database record after changing something in the User Form:

Please Login or Register  to view this content.

Hope this helps

Ochimus

Thanks that’s great!

Any idea on the delete function?

[Ochimus]

Ashley,

Glad it helped, although you don't need to repost the submission.

A DELETE macro depends on the structure of your worksheet.

Assuming your data is in a Table, create a dummy entry, then select VIEW and RECORD MACRO and record how you delete the Table row.

You can then replicate the "FIND" Macro up to the point where it copies data into the User Form, then add the code you have just recorded that deletes it.

Ochimus



Ochimus