I have a user form that uses standard text boxes to display info obtained from a worksheet. All of the info is contained in a single row of that worksheet. The cells that are copied to the form (39 cells which is too much for a standard Excell Dataform) contain various data types such as dates, text and currency amounts. The cells in the worksheet are properly formated to display the data as per the appropriate type. When I copy the cell content to the form, I lose the formating information. Currency amounts such as $3.00 appear as 3. The code I use to display each cell from the sheet to the form is:
My question is:
How can I format the textbox so that it displays the data in the appropriate format. I can't seem to find the right method to do this.
Any help would be appriciated
Bookmarks