Textbox value automatically selected, How?

  • Thread starter Thread starter Kevlar
  • Start date Start date
K

Kevlar

This has to be a simple one.

When opening a userform I would like the value stored in the firs
textbox to be selected. Therefore I can just start typing over th
current value. Currently I have to click and drag the mouse over th
old value to select it
 
Kevlar

Try


Private Sub UserForm_Activate()
Me.TextBox1.SelStart = 0
Me.TextBox1.SelLength = Len(Me.TextBox1)
End Su
 
That works well. Thanks

Now, how do I get the list of choices in a listbox to default to th
top ite
 
Option Explicit
Private Sub UserForm_Initialize()
Me.ListBox1.ListIndex = 0
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Value from Textbox to next cell in range 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Macro for Calendar 1
Verify Textbox Information is a Number and Not Text 6
Populating a UserForm'sTextBox with a value 4
Macro: Copy a worksheet and rename it to a specified value 2
Userform textbox string to header causes unwanted double spacing 4
how do I enter cell value automatically to textbox? 2

Back
Top