userform caption format

[Gvlewis81]

Hi,

i'm trying to format a caption to be a number 0001 (looking at the last used number in a worksheet to generate the next).

Unfortunately the below code is still producing a single number and not the required 0001 format.

Format(EWOno.Caption, "0000")

Help appreciated

 

[Andrew Poulsom]

What's EWOno and what is it's current caption?

 

[mikerickson]

That format will change a number into a four digit string.
But it will leave a 1-character long numeral (string) alone.
Since the caption is always a data type string, try

Format(Val(EWOno.Caption), "0000")