highlighted text
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? |
highlighted text
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 -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=546556 |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com