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

[Simon205]

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