Format Textbox in vba excel

Question

I have a form that fills textbox with the value in a specific column on the active row. I have one problem, the column is numeric but has the character"-" for e.g 0000-00-000-000 I want the textbox to format as 0000000000000 when the form opens. I use the code below but it doesnt do anything

Private Sub UserForm_Initialize()
Dim r As Long

    r = ActiveCell.Row

    Me.TextBox1.value = Cells(r, 9).value
    TextBox1.Text = Format(TextBox1.Text, "0000000000000")
End Sub

SeanC · Accepted Answer · 2016-09-23 20:06:50Z

1

replace is the function that will manipulate the string as required.

The simplest way would be to simply remove the dashes by replacing them with an empty string

TextBox1.Text = replace(TextBox1.Text,"-","")

answered Sep 23, 2016 at 20:06

SeanC

16k5 gold badges48 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Format Textbox in vba excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related