Initializing a form… (Word 97)

Topic

New Reply

I have a user form with initialized values:
txtNumRows.Text = 2
txtNumCol.Text = 2

When the user click the macro button and receives the user form, the values are appropriately populated, but I would like them to be highlighted/Selected, so that they don’t have to backspace to alter the value. I can’t seem to find the property that will do that…. Help Please…..

Reply | Quote

Replies

Well,

Since they are two separate text boxes, you can’t select both. You can only select one.

txtNumRows.SelStart = 0
txtNumRows.SelLen = len(txtNumRows.Text)

However, it you put that code in the GotFocus event of the Text box, the value will be selected whenever the text box receives the focus.

Reply | Quote

Worked like a charm! Thanks!

Private Sub UserForm_Initialize()
‘Set row value to 2
txtNumRows.Text = 2
txtNumRows.SelStart = 0
txtNumRows.SelLength = Len(txtNumRows.Text)

‘Set Column value to 2
txtNumCol.Text = 2
txtNumCol.SelStart = 0
txtNumCol.SelLength = Len(txtNumCol.Text)
End Sub

Reply | Quote

Ooops….
When the user form comes up, the value was 2 (highlighted). I press 6 and the number 66 appears?
When I tab and alter the second value, no problem….. what’s up?

Reply | Quote

I found it,
In my playing/testing, I had dropped the line of code that was carrying over:

Private Sub txtNumRows_Change()
txtNumRows.SelText = txtNumRows.Text
txtNumRows.SelLength = Len(txtNumRows.Text)
End Sub

Reply | Quote