PDA

View Full Version : Solved: Floating listbox to navigate within a single worksheet



Lukacs
05-22-2008, 11:22 AM
Dear experts,

I would like to have a floating listbox called ?PIR Navigation? that lists the different section headings that occur within one worksheet, so that I may click on one of the heading titles in the listbox and be taken to that area in the worksheet.

For example:

Cell B3 ? ?Section A - Summary Schedule?
Cell B50 ? ?Section B ? Summary Information?

I tried to adapt some code written by tstav that allows for the navigation between different sheets, but just made an awful mess.

Anyhow, I?ve tried and tried ? appreciate any help to get going on the right foot ?

File attached.

lucas
05-22-2008, 07:04 PM
Try the attached. Fill in your info on the Sheet Nav which can be hidden when you have it fixed the way you want it.

Lukacs
05-23-2008, 05:12 AM
Fantastic - works great.

Thank you so much for your help.

lucas
05-23-2008, 06:01 AM
Be sure to mark your thread solved using the thread tools at the top of the page..