Text Box Formatting

E

Emile Zac

On my spreadsheet C1 equals the text "Current Portfolio"; C2 is a currency
value of "$50,000".

I wanted to create a TextBox that would concatenate the two cells. The
results should be "Current Portfolio $50,000"

Formatting the font for the TextBox is simple.

When the currency value appears in the TextBox it loses it's currency
formatting. Can I retain the currency format in the textbox? Also,I
haven't figured out the concatenate code as yet.

Any help would be appreciated

Still learning.
 
K

K Dales

You can use this formula to get what you want

=C1&" "& DOLLAR(C2) (Excel function)

- OR -

TextBox1.Value = Range("C1").Value & " " & Format(Range
("C2").Value, "Currency") (VBA function)
 
Top