how to use an Excel function within an udf

[jollycub]

I would like to create an udf with the text function. For example: wojob=text(wo,"ooooo") & text(job, "ooo") with wo being the value in one cell and job is a other. Thanks.

[AlphaFrog]

VBA has a Format function that is almost the same as the worksheet TEXT function.
wojob = Format(wo, "00000") & Format(job, "000")

Or you can use the TEXT function like this...
With Application.WorksheetFunction
wojob = .Text(wo, "00000") & .Text(job, "000")
End With

[AlvaroSiza]

<Frog wins> <sigh>

[AlphaFrog]

You're still more interesting than me Al.

[jollycub]

Thanks, here is my function:

Please Login or Register  to view this content.