Code to Seacrh and Delete database records on UserForm

G'day Excel Gurus,

I'm new to VBA and creating UserForms. I am in the process of developing a pers data and NOK register for my workplace. I have set up a userform where the data can be entered and on pressing a save button on the userform, the data is stored in a worksheet. That works fine.

What I need is advise on how to create a 'search' code and a 'delete' code for two userforms. One userform will be used to retrieve all the data based on a seven digit employee ID number in order to edit or update the info. The other userform is to delete all record of the person. Sounds simple enough, but I cant figure it out (being new to VBA)

Any help is greatly appreciated.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Hello Fogsta65,

Welcome to the Forum!

I changed your title to match your question. Can you post a sample of a workbook with sensitive and or personal information redacted?

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

Hello Fogsta65,

You're welcome. Even zipped the file won't upload? Are you getting any messages as to why it won't?

Hello Fogsta65,

If there is no sensitive information in the workbook, perhaps you could upload it to file sharing sight like MediaFire. Nevermind, if the file is too big for network that option won't work.

Hello Fogsta65,

If you have a flash drive, copy the file to that and then upload it.

Hi Leith,

I have created the database for staff addresses and emergency contacts using userforms for initial data entry, amendments and deletions. I've worked most issues out myself but I'm having a mental blank with the 'delete record' function. My code will only delete from one worksheet called "Recall". I need the function to also delete the same row (person) from sheets called "Staff" and "PEC". The row to delete is derived on the userform using a cmb EMPL ID box that is unique to each person. A problem I also experience is when I click 'NO' to the "are you sure you want to delete" prompt... it still deletes the row from the main sheet. Here is what I've got:

Please Login or Register  to view this content.

Any help, as usual, is greatly appreciated.

Hello Fogsta65,

This should take care of the problems.

Please Login or Register  to view this content.

Hello Fogsta65,

I tested the code before posting it. The message box works correctly. Did you use the macro I posted?

Hello John,

Sorry I am get back to you late. This will work. I forgot to add an exit from the macro when the user answers no.

Please Login or Register  to view this content.

Hello John,

Is this an ActiveX Combo Box?