Using a combo box to search to delete the specific row

Hi i am new to VBA and am having difficulties with numerous areas but this is the problem i seek to solve first. I have been trying to make a combo box search a column (which is a dynamic Range and updates automatically) and highlight the whole row from the what the user selects then delete the whole row when okay is entered. You can find the code that im working on under userform DeleteAsset.


Thanks in advance!

Hi Mr.Steel
Welcome to the forum
See if the attached works for you
I have modified your existing macro
barry

Thanks very much for taking the time to help me out! I Really appreciate it, this couldn't work any better. Have a wonderful day and happy excelling.

Thank you for your comments.
Glad you are sorted.
If you are satisfied then pleas emark your thread as asolved as follows:
Click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.