Hello,
I have a combobox that I generated through the toolbox. My code looks as such:
Private Sub ComboBox1_Change()
With Me.ComboBox1.TopLeftCell
..Offset(0, 5) = "NI"
..Offset(0, 6) = "UT"
..Offset(0, 7) = "ZAT"
..Offset(0, 8) = "ZB"
..Offset(0, 9) = "ZA"
..Offset(0, 10) = "Z1A"
The name of the combobox is "General" anytime I drop down this combobox to
make an item selection ( which produces the list above), the list desired
does come up, however I want to make it so that whenever Im done looking at
the generated list, I can go to the combobox and be able to select the
original title of the combobox; "General" and eliminate/delete my list.
|