ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Focus on Control before UserForm(s) pop up (https://www.excelbanter.com/excel-programming/297316-re-focus-control-before-userform-s-pop-up.html)

Bob Phillips[_6_]

Focus on Control before UserForm(s) pop up
 
Jim,

Probably best to use the Activate event, like so

Private Sub UserForm_Activate()
Me.TextBox2.SetFocus
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jim Shores" wrote in message
...
This is a true community, it is.
What about the procedure/method/way to have focus set to a control in

UserForm_Initialize() probably?
I just got back on-platform after ten years ago in 3.1 with the C SDK, I

am in awe. Thanks




All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com