LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Making a text box active when returning to a screen

I'm setting up a program that allows users to review their order, then return
to a previous screen if they need to make changes. Ideally, I'd like the user
to return to the screen with the first field (text box) active with all text
highlighted. I'm using the SetFocus property as such:
frmHeaderInfo.boxEndUser.SetFocus. The text box EnterFieldBehavior is set to
Select All. However, when the user is returned to the screen, the OK button
(last object clicked on that screen) has the focus.

I've combed through previous posts on this topic and appear to be using this
correctly, but clearly am not. If anyone can help me understand the flaw in
my approach, I'd appreciate it. Thanks in advance.
 
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
Returning value of active cell Sergio Excel Worksheet Functions 3 May 10th 23 03:42 AM
Making comments appear in the center of the screen. Tonso Excel Discussion (Misc queries) 3 July 27th 06 12:13 AM
Making a spreadsheet print exactly as it looks on the screen? Liz Excel Discussion (Misc queries) 1 August 31st 05 10:30 PM
Returning active cell Ted Metro Excel Worksheet Functions 2 May 3rd 05 02:47 PM
Making splash screen RB Smissaert Excel Programming 5 January 2nd 04 04:48 AM


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

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"