Looking for a UserForm template with search/update and previous/next buttons...

[anderma8]

I'm pretty new to VB and userforms and I've searched forexisting templates and modified them slightly but I could not create the searchor update function. I’m wondering ifsomeone has a userform template that has the ability to search and update aparticular row of data as well as having a previous/next button to traverse thelist. Thanks in advance!

 

[dmt32]

The built-in Data form may do what want Have a look here:https://www.excel-easy.com/examples/data-form.html

Dave

 

[anderma8]

THANK YOU – this does more than I was looking for. I really like the search functionality andhow easy it is to use! I opened up thedeveloper tab but I can’t seem to find the UserForm or the VB to adjust so Ican port this into an existing spreadsheet. Might you be able to guide me on that? Much appreciated! Mark

 

[dmt32]

The Data form is part of the excel environment so there is no VBA project you can access.

If you want one you can access VBA code then have a look here:http://spreadsheetpage.com/index.php/dataform/home

You can download & use the form for free but for access to code, you will need to pay the author a fee.


Dave