$$Excel-Macros$$ Selecting contents of a control

2011-10-25 Thread Chris Boxall
I should like to be able to select the contents of a TEXT BOX control on a Form. I have moved the focus to the TEXT BOX using the .SETFOCUS method. The box shows the insertion point at the end of any text in the field. However, it would be nice to automatically select (from a VBA macro) the

Re: $$Excel-Macros$$ Selecting contents of a control

2011-10-25 Thread Sam Mathai Chacko
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Me.TextBox1.SelStart = 0 Me.TextBox1.SelLength = Len(Me.TextBox1.Text) End Sub On Tue, Oct 25, 2011 at 8:00 PM, Chris Boxall ch...@boxall.info wrote: I should like to