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