Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with list box
I have a spreed sheet that has different places for information to be added.
I want to make it easier to navagate to the different information areas. I have never used a list box combo box etc. Is there a way to make one of these boxes with my areas listed so when you click on that area you are taken to that area. I did not really want to record allot of macros with Go To buttons. Now if this is possible can this drop down list be added to the toolbar. Thanks in adavance Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with list box
Hi!
Is there a way to make one of these boxes with my areas listed so when you click on that area you are taken to that area. I did not really want to record allot of macros with Go To buttons. You only need one macro and one Go To button. You would, however, need a "Home" button for each location. I do this a lot. if this is possible can this drop down list be added to the toolbar. Possible, but that would require a real "guru" and is probably not something you can get for free in a newsgroup. Biff "scott45" wrote in message ... I have a spreed sheet that has different places for information to be added. I want to make it easier to navagate to the different information areas. I have never used a list box combo box etc. Is there a way to make one of these boxes with my areas listed so when you click on that area you are taken to that area. I did not really want to record allot of macros with Go To buttons. Now if this is possible can this drop down list be added to the toolbar. Thanks in adavance Scott |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with list box
Hi Scott, Just a proposal, why not use hyber links. you may add one sheet in the beginning of your spreadsheet and add different hyber links that may take you to the data entry section when clicked. on each data entry area, you may add a small conrol to take you back to the main sheet. hope this helps khaldoun -- iwtci ------------------------------------------------------------------------ iwtci's Profile: http://www.excelforum.com/member.php...fo&userid=9797 View this thread: http://www.excelforum.com/showthread...hreadid=490281 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Update master list with other lists | Excel Worksheet Functions | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |