Combo box - changing drop down values

[LostinVA]

Hi everybody -

I previously had a drop-down box with a Data Validation list. I then created a combo box in order to have auto-complete. I have since deleted the data that was assigned to the drop-down box via the Data Validation list. I want to assign a new set of data to the drop-down box / combo box but can't figure out how to do it. When I click on the drop-down box now it's just blank and Data Validation only has options for 'Circle Invalid Data' and 'Clear Invalid Circles'.

So when utilizing a Combo Box, is there a way to change or assign a new data validation list? Hope that makes sense. Not very good at explaining myself.

Appreciate any help you all can provide!

 

[My Aswer Is This]

If you have a Activex Combobox and you want to assign a range of values to the Combobox.

1. In Developer mode right click the Combobox
2.Choose Properties
3. Look down list and in ListFillRange
4. Insert something like this: A1:A20
5. This will now put the values in Range("A1:A20") into the Combobox

 

[LostinVA]

Perfect, thank you so much! Appreciate your help!

 

[My Aswer Is This]

Perfect, thank you so much! Appreciate your help!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.