Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i would like to sum only highlighted text in a row | Excel Discussion (Misc queries) | |||
Add text to cells highlighted in rose | Excel Discussion (Misc queries) | |||
HELP!!! I am unable to see colored text or highlighted cells ... | Excel Discussion (Misc queries) | |||
find specific text and make cell highlighted | Excel Discussion (Misc queries) | |||
Highlighted Text And/Or Cells | Excel Discussion (Misc queries) |