Formatting a Textbox
Posted on 2004-10-14
In an XL worksheet I have an assortment of values, both text and numeric...after a transfer of values occursand a User Form is opened, certain of the UserForm fields are automatically filled in via an assortment of VBA routines...so far so good...
Here's my dilema...let's say in the first workbook, Sheet 1, cell A1, I have the value '07'...it successfully gets transfered to another workbook,Sheet2, cell B1, as '07'...when the UserForm opens and fields are auto-updated, the value for the field is 7...i.e., NO leading 0 (zero)...I need the '07' rather than the '7' since a unique ID number is generated from this piece of info...Thoughts???