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


--
Simon205
------------------------------------------------------------------------
Simon205's Profile: http://www.excelforum.com/member.php...o&userid=34662
View this thread: http://www.excelforum.com/showthread...hreadid=544272

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 wrote:

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

--
Simon205
------------------------------------------------------------------------
Simon205's Profile: http://www.excelforum.com/member.php...o&userid=34662
View this thread: http://www.excelforum.com/showthread...hreadid=544272

--

Dave Peterson

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

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

Cheers,


Simon


--
Simon205
------------------------------------------------------------------------
Simon205's Profile: http://www.excelforum.com/member.php...o&userid=34662
View this thread: http://www.excelforum.com/showthread...hreadid=544272