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.
Here is one example of my coding in the userform initializing stage.
Code:
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_)