Formatting text boxes

[Mkammari]

I am using a vba userform to display information that already exists on an excel worksheet entitled "Customer Info". Currently, I am having a very hard time trying to get the userform to display any kind of number formatting. I was using the control source to display the information on the userform but had problems. So then, I tried to code the data in VBA initializing, but still could not get it to work.

Here is one example of my coding in the userform initializing stage.

TxtWeightLow.text = Sheets("customerinfo").Range("b95").Text

Is there another line I would need to add to format the text box. (the cell on the spreadsheet is already formatted)

I would like txtweightlow to read as a ($* #,##0.00_)

 

[Norie]

That code should display B95 in the textbox as it is formatted on the worksheet.

Have you removed the value in the ControlSource property?

 

[Mkammari]

Not really sure what's going on now. I took the control source, the value, and the text out of the properties menu and now I'm not returning a value in the text box.

But the code I provided should return the value exactly displayed in the worksheet. Is that what you are saying?

 

[Mkammari]

Norie...I got it to work. Thanks as always.