I can go to a Form textbox using Textbox1.SetFocus. This does not select the text, although EnterFieldBehavior = 0. Any thought on how to do this?
I can go to a Form textbox using Textbox1.SetFocus. This does not select the text, although EnterFieldBehavior = 0. Any thought on how to do this?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hi Malcolm,
The EnterFieldBehavior doesnt seem to pertain to when the focus is set programmatically.. what I've done in the past is [vba] With TextBox1
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With[/vba]Matt
Thanks Matt,
That'll do nicely!
Regards
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote