Find a name in a colum and insert a row

[osarlandt]

I have a large worksheet with over 1000 rows of information.

I would like to develop a VBA macro to open a search text box and
position the cursor to the cell that matches the text input. ( similar
to the index option in help)

When enough characters have been entered I would like to add a row
below the existing row and position the cursor to the first cell in the
row.

Any code or help would be appreciated!

 

[Earl Kiosterud]

You may wish to add the rows to the bottom of the list, then sort it. Lists
are often sorted on various columns as needed. There's no need normally to
maintain a particular order as you update it.