coding a textbox to search in the worksheet

You need to use the VBA .Find function to find the row, then the rest is simple.

look at the Databaseform example here

http://www.excel-it.com/vba_examples.htm

hi i have some question of how to adapt this to my form here is the code and image so , you that understand better can help me please, only left find by administer personel:
first button = CommandButton1
Previous button = CommandButton2
Next button = CommandButton3
Last button = CommandButton4
save button = CommandButton5
cancel button = CommandButton6
add = CommandButton7

Please Login or Register  to view this content.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Sorry but what is dummy workbook .i post the worksheet, i try the database form example but i receive error and highligth
Set rng = rng.Cells.SpecialCells(xlCellTypeVisible) and .List(.ListCount - 1, 10) = c.Offset(0, 10).Text, this in Sub FindAll(). Sorry for my english.

closing................

When you find a name your code moves the entries on the form, so the name is not displayed in ADM_PERSONNEL as expected.

Rn Debug and you will find an unnecessary End If

Can you view my project again and help me create a link between the find button and the listbox so that i can chose what record of the adm personnel to updated.

......................

....................