another way is to transfer the number and then format the cell to display the
way you want

Cells(27,2) = cdbl(Textbox4.Text)
cells(27,2).Numberformat = "$ #,##0.00"

--
Regards,
Tom Ogilvy


"ryguy7272" wrote:

Sorry for not explaining the issue better. The problem is that I am taking
input from the UserForm and transferring it to the SS. I want to try to
format the value as currency when the user is entering data in to UF. I
already have the formatting that I need when the data goes from the SS to the
UF.

Any ideas?



" wrote:

On 3 Aug, 14:48, ryguy7272
wrote:
Thanks to several people who use this DG, I just recently learned how to
format data coming from a SS to a UserForm. I am wondering if there is a way
to format data on the UserForm, to make it easier for the user to quickly and
easily distinguish between, let's say 1000000 and 10000000. I tried the
following:

Format(Cells(27, 2), "$#,##0.00") = TextBox4.Text

That didn't really seem to do anything at all. Does anyone have any
suggestions as to how to do this?

Cordially,
Ryan---

Isn't your version backwards?


TextBox4.Text=Format(Cells(27, 2), "$#,##0.00")

would seem more likely