Combo Box properties problem

[Simon205]

Hi,

Does anyone know how to ensure that a cell's text formatting properties
carry through to the selected value in a combo box?

For example, if the combo box is linked to a cell with the value 400,
with text suffix of "mm", how do I get the combo box to display
"400mm" when selected?

Thanks for any help,

Simon

Excel 2000

 

[Dave Peterson]

You could load the combobox with code.

I used a combobox from the control toolbox on worksheet 1:

Option Explicit
Sub testme()

Dim myRng As Range
Dim myCell As Range

With Worksheets("sheet1")
Set myRng = .Range("a1:A10")
.ComboBox1.Clear
For Each myCell In myRng.Cells
.ComboBox1.AddItem myCell.Text
Next myCell
End With

End Sub

 

[Simon205]

Ok, well I've never got into VB code before, so that's way over m
head!

I was hoping there'd be a properties option I'm not aware of, bu
thanks for your help anyway?

Cheers,


Simo