Userform to retrieve update and delete data

**moneypennie21** · 05-25-2022, 08:00 AM

I am very new to the whole userform process, I have created a basic userform to enter details but how do I make it so I can use the form to search for existing data, display it and edit it?

I would like to use the employee id as the data that I enter and use as the basis for the search as this is the unique identifier

I have attached my basic sheet with the userform on it on the macro under ENTER new details button

any help would be appreciated. I have found some explanations online but they assume a lot of knowledge, this is literally the first userform I have ever created!

**torachan** · 05-25-2022, 11:41 AM

try the attached, it is the basic approach that I use for most of my applications.
you will notice I have altered your data to a 'structured table' rather than just a range list.
structured tables are self maintaining - do not add extra blank rows at the bottom - the table will expand/contract dynamically when you add/delete data.
you can enter new data/ update existing or remove all on the one form.
to enter new data first press 'Clear' this ensures a clean form and activates the 'Add' button.
fill in your data on the form and press 'Add'
to select data for updating or deleting use the combobox dropdown the rest should be intuitive.
all the code is in the userform module and should be more or less easily readable (to assist I have added a pdf of the code flow)
only oddity to explain, there is a textbox embedded above the combobox kept in place by the ZOrder of each control.
any questions post back on this site.

**moneypennie21** · 05-26-2022, 04:09 AM

torachan this is perfect thank you so much. The PDF of the code is really useful. Very much appreciated.

You were right on my previous post that userforms are better I just hadn't got the time to learn it then due to a tight timeline but I will study this code and understand it.

thank you again for the help.

**moneypennie21** · 05-26-2022, 04:10 AM

tried to give you some reputation but as I already did on a previous post i won't allow me to again!

Userform to retrieve update and delete data

LinkBack

Thread Tools

Rate This Thread

Display

Userform to retrieve update and delete data

Re: Userform to retrieve update and delete data

Re: Userform to retrieve update and delete data

Re: Userform to retrieve update and delete data

Thread Information

Users Browsing this Thread

Similar Threads

Search/update/delete records in userform

[SOLVED] Update/Delete data in datasheet based on userform checkboxes

[SOLVED] Delete/Update/Add/Search records in userform

On Userform, how to put Search, Delete, Add, Update buttons

[SOLVED] userform was able to retrieve data from a workbook and then update not working

How to add, update or delete data on a Worksheet using a userform

Userform enter data/update data/delete data

Bookmarks

Bookmarks

Posting Permissions