 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / April 2008Navigate Windows
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 > Is there a faster way to pick a window than to go to the Menu bar. It > would [quoted text clipped - 7 lines] > > 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 > Are you talking about navigating between open workbooks? > [quoted text clipped - 22 lines] > > > > 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/Workbook_Navigator/workbook_navigator.htm Let me know if you need any help. Mark Ivey > Mark, > [quoted text clipped - 38 lines] >> > >> > 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 > 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. [quoted text clipped - 51 lines] > >> > > >> > 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 > Incredible. Thank you. I am working on just clicking the listbox1 so it > is [quoted text clipped - 70 lines] >> >> > >> >> > 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 ------------------------------------------------------------------------------------------- > Not totally sure what you were asking for... > [quoted text clipped - 83 lines] > >> >> > > >> >> > Steven Steven, See if you can run this procedure to sort your listbox... http://www.dailydoseofexcel.com/archives/2004/05/12/sorting-listboxes/ Mark Ivey > Lets forget my last repsonse. I do have one more question. I added a > couple [quoted text clipped - 117 lines] >> >> >> > >> >> >> > 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 > Steven, > [quoted text clipped - 125 lines] > >> >> >> > > >> >> >> > Steven 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. [quoted text clipped - 143 lines] >> >> >> >> > >> >> >> >> > Steven |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.