VBA: Search for a user input string in table & delete the row containing that value

[cainey1991]

Hi all,

ID	name
a-1	red
a-2	blue

<tbody>
</tbody>

I am wanting a input box to appear and the user types in a string "a-2" and it will then search the table "table1" and delete the row containing that string.

Any help would be appreciated.

D

 

[cainey1991]

Works like a dream. Much appreciated !