LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Code equivalent to Alt + Tab

No apology necessary. I think it just depends on how much "clutter" or extra
stuff you want.



Jimbob wrote:

My very sincere apologies Dave. I didn't mean to disrespect your elegant code
or your efforts on my behalf. It's just that, being an ignorant sort, I
couldn't understand it at first and your shorter option worked first time.
Now that I've studied your first option, I can see it has some robust
features.

Apologies again and, once again, many many thanks for responding.
Regards
Jimbob

"Dave Peterson" wrote:

I don't know. All that malarky did some nice checking.

But glad you have something you can use.

Jimbob wrote:

Bravo Mr P. You are my Number 1 Star.
Thank you so much (and far easier than all that mularky earlier!)

"Dave Peterson" wrote:

Ps. If you just want to cycle through the open windows, you can use a macro
with a line like:

ActiveWindow.ActivateNext

(Slightly less code <vbg)

Dave Peterson wrote:

<<snipped
--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


 
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
What's the vba code equivalent for Countif NDBC Excel Discussion (Misc queries) 3 July 4th 09 11:42 AM
CODE Function equivalent in VBA Edmund Excel Programming 3 September 13th 06 03:14 AM
Does XML have equivalent code for ADO? XP Excel Programming 1 February 22nd 06 05:22 PM
Indirect equivalent in VBA code Ken Rock Excel Programming 2 September 24th 05 02:25 PM
Code equivalent to the Enter-Key JMay Excel Programming 7 May 23rd 04 08:44 PM


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