Rlb53
01-29-2012, 06:59 PM
1: I am returning VALUE into a textbox within a Userform.
The range in which the VALUE is acquired has been formatted to display as a WHOLE NUMBER without decimal places.
The VALUE returned into the textbox is displayed as the actual number which contains numerous decimal points.
I wish for the VALUE returned to be displayed as a WHOLE number without decimal places.
How may this be accomplished?
2: What may be added to the "Userform.show" command to call for the VALUES to be displayed within the textbox when the Userform is opened?
Thank you for your assistance.
The range in which the VALUE is acquired has been formatted to display as a WHOLE NUMBER without decimal places.
The VALUE returned into the textbox is displayed as the actual number which contains numerous decimal points.
I wish for the VALUE returned to be displayed as a WHOLE number without decimal places.
How may this be accomplished?
2: What may be added to the "Userform.show" command to call for the VALUES to be displayed within the textbox when the Userform is opened?
Thank you for your assistance.