Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change focus from Userform back to Sheet rocketslinger[_2_] Excel Programming 5 January 11th 04 02:31 PM
Taking focus off a Control Checkbox Don Wiss Excel Programming 1 November 11th 03 12:18 AM
Focus back from modeless userform to sheet RB Smissaert Excel Programming 4 September 5th 03 04:21 PM
UserForm Loss Focus Orlando Magalhães Filho Excel Programming 2 September 5th 03 04:47 AM
Must be a way to force focus back to sheet instead of UserForm - isn't there? Les[_4_] Excel Programming 2 July 29th 03 12:45 PM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"