ComboBox Properties:
ListFillRange: C22:C28
LinkedCell: AL16
BoundColumn: 1
ColumnCount: 1

Column Column
B C
Row 22 0 Text 0
Row 23 1 Text 1
Row 24 2 Text 2
Row 25 3 Text 3
Row 26 4 Text 4
Row 27 5 Text 5

Needed: if user selects, for example, Text 3 (in cell C25) from the
ComboBox, I want the value in cell B25, €œ3,€� to appear in the LinkedCell AL16
€“ rather than Text3. What would the code be to make this work?

Thanks, Phil