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

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

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