Format Textbox for phone number

[ipbr21054]

On my userform I have Textbox9 which will hold a phone number.

I currently populate my user form with values from my worksheet.

On my worksheet I see phone numbers like so 07899 327122

I populate the Textbox9 but the leading 0 is missing thus me only seeing 7899 327122

Please advise what code I need to use so the full number is shown with its 0

Thanks.

 

[ipbr21054]

I used the code supplied but changed it for the correct column from 18 to 23 now works fine.
Thanks

UserForm1.TextBox6.Value = Format(Cells(ActiveCell.Row, 23).Value, "00000 000000")

 

[CephasOz]

Good to hear that you have what you need.