Help with Text Boxes

[Rockets]

Hi,

I have 5 - 6 lines of text, with some numbers in between, in a text box. Right now the numbers are hard coded.

I am wondering if I could replace the hard coded numbers with references to a cell. I cannot use the formula bar as that would prevent me from formatting the text.

Any help would be greatly appreciated.

Thanks

[Bryan Hessey]

Hi,

I have 5 - 6 lines of text, with some numbers in between, in a text box. Right now the numbers are hard coded.

I am wondering if I could replace the hard coded numbers with references to a cell. I cannot use the formula bar as that would prevent me from formatting the text.

Any help would be greatly appreciated.

Thanks

even if the numbers were changed by VB code the format would still be lost.

You can have a formula to change the numbers, or, Text to format.

hth
---

[mudraker]

Private Sub UserForm_Activate()
Me.TextBox1.Text = "The value in cell A1 is " & Range("a1")
End Sub