ComboBox – Used to Score

[Phil Hageman]

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

 

[Martin Fishlock]

Phil,

Change the details to

ListFillRange: B22:C27/8 ?
LinkedCell: AL16
BoundColumn: 1
ColumnCount: 2

and add columnwidths: 0;2in or what ever
and it should work.

 

[Phil Hageman]

Martin, Worked perfectly - I had to have the number in the LinkCell for
further calculations. Grazie from Naples Italy! P