Creating search and update command buttons in a userform

janb Posts 1 Registration date Friday June 28, 2013 Status Member Last seen June 28, 2013 - Jun 28, 2013 at 12:01 PM
 ShezzyWiggle - Mar 24, 2019 at 09:51 AM
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command buttons already using VBA code.

Now I want to add a command button that will perform a search of a specific field (LName) in all records.

I also want to add a button that will update a record that has been modified.

I'm not sure what code to use.

Thanks for your time.

6 responses

kadrleyn Posts 5 Registration date Saturday March 21, 2015 Status Member Last seen May 11, 2021 19
Aug 21, 2015 at 11:44 AM
Hi ,

I made an advanced userform example .
Really it's many features .
- Data Adding
- Data Delition
- Data Update
- Searching with The Userform
- Progress Bar Feature
- Scrolling the Listbox with Spin Buttons
- Next ,Previous ,First ,Last Recording Buttons
- Sheet Hide / Show Features with Toggle Button

It's really grate Userform, can you please upload the same with 24 columns means 24 taxbox. I had tried to do that but unable to update code as I am purely from Finance background & unable to add/update code for the same. so addtional/updation is not working properly.

i need this file please send me on ***@***