padding out zeros in textbox

Hello,

I have a userform with textboxes. One of the textboxes must be a string with 12 characters long (numeric). If the user only inputs 4 digits then I want the textbox to automatically fill the rest of the string with zeros (I want the zeros to be padded out to the left so the numeric digits go to the right)

Does anyone know what code I could use to make this happen and where the code would go? (ie textbox, command button etc)

Thankyou!

No I dont think so

Thankyou again! It works but i need the total string to be 12 characters long, eg if the user puts 1111 then there would be 8 zeros padded out. At the moment if the user inputs 4 digits then it is giving a further 12 zeros....any ideas?

Thankyou

Thats brilliant thankyou so much again