Delete Selected Data on A Range Using ComboBox

Good Day!

I Knew there should be a short code with this excel vba i have attached below
What I did on my attached file excel vba is a long coding method because i dont know how to do it using range code.

Scenario:

Whenever i choose name using combobox it will display on txtName.text for Name chosen
and respectively display txtNumber.text for Student Number
What i want is that i want to delete that row containing that txtName.text and txtNumber.text based on comboBox selection



i have added the long code in my attached file and it works but i dont want to code it in a long method
I just want help how to have a short code with this!


I knew already how to Edit data based on combobox selection with the help of Sir 6StringJazzer
This one, i want to totally delete the row containing the data base on the combobox selection




Thank You So much and have a nice day Ahead