Combo Box Link to Cell- Number not Text

[OldDogNewTricks]

I have an ActiveX combo box with drop-down number options 1 through 4. Whichever option is chosen needs to appear in cell T21. To do this, I went to properties, LinkedCell, and typed in T21. Unfortunately, whenever the list options appear in cell T21, they appear as text. I need it to appear as a number. Any advice on how to do this?

Thank you!

Note: I am using Excel 2007.

 

[Gavin T]

Instead of using a linked cell, try this:

Private Sub ComboBox1_Change()
    Range("A1") = ComboBox1.ListIndex + 1
End Sub