ComboBox with Value?

[liquid1010]

I am looking at using a SUMIF function based on a selection that the user makes in a ComboBox. However, because the ComboBox returns a numeric value (ie: 1,2,3), it's not possible. Is it possible to have a box return the name they select rather than a value?

[BigBas]

Could you use a Data Validation dropdown instead of a combobox?

[liquid1010]

Could you use a Data Validation dropdown instead of a combobox?

I'm not sure what that is.

[VBA Noob]

See link

http://www.contextures.com/xlDataVal01.html

Examples to download here

http://www.contextures.com/excelfiles.html#DataVal

VBA Noob