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;
havent found the answer yet. Any help would be greatly appreciated!

Regards,
Ryan---


--
RyGuy

Ryan,

Try something like this:

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

--
Hope that helps.

Vergel Adriano


"ryguy7272" wrote:

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;
havent found the answer yet. Any help would be greatly appreciated!

Regards,
Ryan---


--
RyGuy

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

Try it this way...

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

Rick

Sorry Vergel,

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

Rick


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

Try it this way...

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

Rick

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

--
Regards,
Tom Ogilvy


"Rick Rothstein (MVP - VB)" wrote:

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

Try it this way...

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

Rick

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


"Vergel Adriano" wrote:

Ryan,

Try something like this:

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

--
Hope that helps.

Vergel Adriano


"ryguy7272" wrote:

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;
havent found the answer yet. Any help would be greatly appreciated!

Regards,
Ryan---


--
RyGuy