Changing Combo Box Selection Value

[woods22]

How do you change the value of a selection in a Combo box? Such as selection 1 of the box returning the value of 1 in the linked cell. I need to select "weekly" being the first item in the box and it return "52" in the linked cell and not 1.

I am new to VBA coding so any help would be greatly appreciated.

Thanks!

[paulked]

A combobox on a sheet will only return its selection index.

see this example

18574

[mdmackillop]

You can return the value from a second hidden column