Percenatge Format in TextBox

[Guest]

I am using a few simple lines of code in a TextBox such as:

TextBox6.Value = Cells(290, 3)

This takes a value from a cell, and displays it on my UserForm. The only
problem is that it is always displayed in the TextBox in a format such as .2,
or .493, or some such thing. I am trying to get the TextBox to display the
value in percentage format, perhaps even with two decimal places. How can I
do this? I tried the Macro Recorder, and I looked on several web sites;
haven’t found the answer yet. Any help would be greatly appreciated!

Regards,
Ryan---

 

[Guest]

Ryan,

Try something like this:

TextBox6.Value = Format(Cells(290, 3), "##0.00%")

 

[Rick Rothstein \(MVP - VB\)]

TextBox6.Value = Format(Cells(290, 3), "##0.00%")

Try it this way...

TextBox6.Text = Format$(Cells(290, 3), "0.00%")

Rick

 

[Guest]

Excellent! That's exactly what I was looking for.
Thanks so much!!

 

[Rick Rothstein \(MVP - VB\)]

Sorry Vergel,

My post was not directed at you... I meant to post it to the OP.

Rick

 

[Guest]

What I have read is that there is no advantage to using the $ versions of the
function in current versions of VBA. (implications are that they executed the
same).

? typename(Format$(.23, "0.00%"))
String
? typename(Format(.23, "0.00%"))
String