MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format a Number

Posted by Tee on June 25, 2001 6:39 PM

Hi everyone

Can anyone tell me how to format a number in VB code so as when the user form loads, the number format is displayed in the text box.

eg. Format (txtNo, "V########")
Display in text box as V_ _ _ _ _ _ _ _


Posted by Russell on June 25, 2001 8:29 PM

You're close: replace the #'s with 0's (zeros)

Posted by Tee on June 25, 2001 10:40 PM

Re:Like an input mask

Thanks Russell - but I want it to be like a Input mask in Access