Navigate Windows

[Steven]

Is there a faster way to pick a window than to go to the Menu bar. It would
be nice if there was a fast way to make a popup come up in the middle of the
screen with the names of the open windows on it to select. Going to the Menu
bar is a bit cumbersome.

Thank you for your help,

Steven

 

[Mark Ivey]

Are you talking about navigating between open workbooks?

If so... you can use an CNTL + TAB command to quickly navigate from workbook
to workbook...

If you want a popup window, I think I saw an addin on the web you could
purchase.

I actually created another version of my own.

If you are interested in trying out the version I made, just let me know and
I will see about sending you a copy.

Mark Ivey

 

[Steven]

Mark,

Thank you for repsponding. Is this something you can post here? I am at
work and cannot recieve emails from this website's contacts. If you cannot
put the code in a response, can you get me going in the right direction
conceptually?

Thank you,

Steven

 

[Mark Ivey]

What version of Excel are you using? The one I designed was for Excel 2003,
but it also seems to work fine in Excel 2007.

Here are some brief instructions on how to build the version I built. After
you get it working, it shouldn't be difficult to turn it into a VBA type
addin.

http://www.graceba.net/~wmivey/Workbook_Navigator/workbook_navigator.htm

Let me know if you need any help.

Mark Ivey

 

[Steven]

Incredible. Thank you. I am working on just clicking the listbox1 so it is
fast ... I commented out where the user must pick the sheet. I will just
accept the sheet where the file is currently.

Question: Is there a way to make it so it goes to the file on a single
click. I have tried a few things with no success.

Thanks for your help. This is a very nice feature.

Steven

 

[Mark Ivey]

Not totally sure what you were asking for...

"Question: Is there a way to make it so it goes to the file on a single
click. I have tried a few things with no success."

Are you wanting it to launch after selecting the Worksheet (without the need
for a commandbutton)?

If so, you could play with the AfterUpdate feature for that particular
ListBox in the userform module.

Mark Ivey

 

[Steven]

Lets forget my last repsonse. I do have one more question. I added a couple
lines in the ShowWorkbooks so the current file will be the one selected when
the UserForm1 shows:

ThisFileIndex = 0
For Each wb In Workbooks
..ListBox1.AddItem wb.Name
If ActiveWorkbook.Name = wb.Name Then GoToThisFile = ThisFileIndex
ThisFileIndex = ThisFileIndex + 1
Next

..ListBox1.ListIndex = GoToThisFile

Thanks for all your help and knowledge. This Navigator is going to make my
day much more enjoyable.

One last question: Is there a way to make the listbox sort ascending?

Thank you,

Steven
-------------------------------------------------------------------------------------------

 

[Mark Ivey]

Steven,

See if you can run this procedure to sort your listbox...

http://www.dailydoseofexcel.com/archives/2004/05/12/sorting-listboxes/


Mark Ivey

 

[Steven]

That about does it. It works perfect. Thank you very much for your help.
This is something I am going to enjoy every day.

Steven

 

[Mark Ivey]

Glad I could help out...

Mark Ivey

That about does it. It works perfect. Thank you very much for your help.
This is something I am going to enjoy every day.

Steven