UserForms - Editing and Search Existing Data

Hello

I am new to the forum and an on-and-off dabbler in VB for Excel.

Today I have started pulling together a basic project that logs telephone calls, including some dynamic lists for populating dropdowns etc.

Based on searches across the web, I have managed to pull together a spread sheet that has:

• Data entry form for users to log new telephone calls
• Form for viewing and browsing through existing data (with no editing enabled)
• Data entry forms to add new items to the lists that drive the combo boxes on the various forms

What I want to do to finish off this project, but cannot seem to find an article that explains it enough for my brain to understand is:

• Data form that allows users to browse records and make changes i.e. save the data back to the worksheet
• Enable a users to search for telephone calls by ID and Name

I have included the latest version of my spread sheet below, if anyone can point me in the right direction or provide the code that offers the above functionality, I would be extremely grateful!

Thank you in advance for any help.

All this is what Access database is for. It can do all this without vba programming.

Hi ranman256

Unfortunately, using MS Access is not an option due to compatibility issues.

Thanks

freyasan