highlighted text

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

In the "Save as" box, the name of a workbook is pre-highlighted for you to
change it. How do I do the same in a user form ?

I have a form with a text box... say txtbox1, I also have set a default
value of "0" in the txtbox1.
I set focus on txtbox1 when form is shown but the zero is not hightlighted
like I want...

Any tips?
 
Hello MD,

Copy and paste this code into a standard VBA Module.

To add a Module to project:
1) Press Alt + F11 in Excel to open the VB Editor
2) Press Alt + I to activate the Insert menu
3) Press M to add a Module

Public Sub HighlightTextBox(TextBox_Name As String)

'Highlight TextBox Text

With UserForms(0).Controls(TextBox_Name)
..SetFocus
..SelStart = 0
..SelLength = Len(.Text)
End With

End Sub


Calling the Macro:
Enclose the name of the TextBox whose text you want to highlight in
quotes.

HighlightTextBox "txtbox1"


Sincerely,
Leith Ross
 

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

Back
Top