Value From Forms Combo Box Control

I have a (form control) combo box in my worksheet. Inside the combo box are several different ways a data set might be sorted. I would like to refer to the current selection of the combo box in my VBA code because I have a macro which executes differently based on the selection in the combo box.

I have found this piece of code which I know executes when the combo box selection is changed.

Sub DropDown1_Change()

However, I still do not know how to refer to the value of the current selection.

Below was my attempt to assign the current selection to a name, ComboValue, that I created:

Sub DropDown1_Change()
Names("ComboValue").value = ComboBox1
End Sub

Strangely, this code executes once, but removes the name I created. It then returns an error on subsequent runs.