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: 115
Default Activating a tab within a window

Using tab keys I'm unable to 'activate' tabs within my window in a workkforce
management program. I need to do this in order to be able to run data
through to this tab from Excel.

I've written the code the populate each tabbed window separately but would
like to combine the code by activating the next tab and using 'sendkeys' to
send a {RIGHT} to select this next tab.

I've tried many combinations of ctrl/alt/shift/F keys etc without success.
I've also tried tabbing through the fields in the first window but this only
leads me out into the left pane explorer window.

Is there any VB code I could use to activate the second tab in the window?
Or Perhaps a combination of 2 or more keys whicih I could 'send' to the
window?

Many thanks for your help.
 
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
Activating EXCEL window from PowerPoint Barb Reinhardt Excel Programming 0 August 17th 07 02:06 AM
changing sheet in window without activating it rumi Excel Programming 0 September 13th 05 02:16 AM
Grabbing data from diff window w/o activating it McManCSU[_28_] Excel Programming 1 August 18th 05 08:44 PM
Error on activating a window a open workbook Hari[_3_] Excel Programming 1 June 11th 04 12:58 AM
De-Activating the menu option, Window - Unfreeze Mario[_6_] Excel Programming 0 January 12th 04 06:57 PM


All times are GMT +1. The time now is 02:39 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"