Hi Bruce,

Try:

Me.TextBox1.Value = Format(Range("A1").Value / 100, "0.0%")


---
Regards,
Norman



"brucemc" wrote in
message ...

In a cell I might have 15 or 15.5.

In the text box that is NOT linked to the cell but gets it's value from
it in the activate function, I want it to display 15.00% or 15.50%.

I want the user to be able to change that number, and when they are
done, it to show to two decimals and the "%" sign.

Is there any direct formatting command, or am I going to "get" to go
through all kinds of gyrations of switching it to string, adding or
truncating charaters, displaying, checking for changes (if possible)
and reformatting for display?

Thank-you for all thoughts!


--
brucemc
------------------------------------------------------------------------
brucemc's Profile:
http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=557505