Help with list box

[Guest]

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

 

[Biff]

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

 

[iwtci]

Hi Scott,

Just a proposal, why not use hyber links. you may add one sheet in th
beginning of your spreadsheet and add different hyber links that ma
take you to the data entry section when clicked. on each data entr
area, you may add a small conrol to take you back to the main sheet.

hope this helps

khaldou