ComboBox €“ Used to Score
 

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

ComboBox €“ Used to Score
 

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Phil Hageman" wrote:

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

ComboBox €“ Used to Score
 

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


"Martin Fishlock" wrote:

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Phil Hageman" wrote:

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