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

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" wrote in message
...
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,

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" wrote:

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" wrote in message
...
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

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

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" wrote in message
...
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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

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" wrote:

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" wrote in message
...
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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

Steven,

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

http://www.dailydoseofexcel.com/arch...ing-listboxes/


Mark Ivey



"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

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" wrote:

Steven,

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

http://www.dailydoseofexcel.com/arch...ing-listboxes/


Mark Ivey



"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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

Glad I could help out...

Mark Ivey

"Steven" wrote in message
...
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" wrote:

Steven,

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

http://www.dailydoseofexcel.com/arch...ing-listboxes/


Mark Ivey



"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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" wrote:

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/Workb..._navigator.htm

Let me know if you need any help.

Mark Ivey


"Steven" wrote in message
...
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" wrote:

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" wrote in message
...
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