Text Box Formatting

  • Thread starter Thread starter Emile Zac
  • Start date Start date
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA currency or percent format object 1
Userform Text box Format to Currency 2
Conditional Formating 1
Formating textbox's on a userform 2
custom currency symbol independent of regional settings 1
Results no longer currency when adding text to formula / formulas based on resulting cell don't work 1
Conditional Formatting Problem with currency. 6
maximum of currency array? 4

Back
Top