deleting cell based off selection in listbox VBA

Hi everyone,
I'm new to listboxes so let me explain what I'm trying to do. I am using the activex control version of the listbox. I switched it in properties to 1-fmliststyleoption and to 1-fmMultiSelectMulti so that there is a checkbox next to each item. Each item in the checkbox is based off a list of another worksheet (in this case that sheet is called "Data") The column that it is basing off of varies depending on what is displayed in combobox1. I have a button (active x or form doesn't matter to me) that needs to delete the data that is selected in the listbox. It needs to clear the data from "Data" and resort the column so that it doesn't have a blank.
I can't delete the entire row, just the cell in the column, and the cell to the right of it.
I am not sure even where to start with that. Can someone please help me?

Bumping this thread due to no response

Bumping this thread due to no response