Delete the all chosed column which is selected in combo box!!!!!!!!!!!!!

Hi Experts,

I wrote a code below, It works like that the choosed text is deleted from Excel sheet. But to delete it I have to click CommandButton2 every time.
I want that when I click command button once it should be delete all column which is choosed in combo box. It is urgent please help me rapidly.

Please Login or Register  to view this content.

Maybe

Please Login or Register  to view this content.

Kind regards
Leo

Thanks Leo, It worked.