Change UserForm data type

[xidnad]

I am creating a UserForm in Excel2000 and I want to change the data type for two of my text box variables to "double" and format them with a comma for the thousand separator and no numbers to the right of the decimal.

Is this possible?

Thanks

 

[fumei]

confused. Are you talking about getting information from textbox and making it a double, or do you have a data source for the textbox?

Gerry

 

[xidnad]

I am not using a data source. I have one textbox that I want the user input (Cost) to display with thousand separators and one that displays a formula value that I also want to display with commas. The formual sums data previously posted in the workbook from the user input (the sum of all Cost entries based on the Identifier). I have formatted the column containing the Cost enties but this has no effect on the data displayed in the UserForm.

 

[fumei]

The textbox on the UserForm is just that, a text box. You will have to format it yourself. Parse the value returned by the formula and make the separators.

Gerry

 

[xidnad]

Thanks Gerry, I was thinking that was going to be my option but I wanted to check if there was another way.