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.
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.