Scroll with a scroll bar???

[repairman615]

Hello,
This is something I have been working on for days...It seems simple enough. I would like to add a scroll bar that will scroll a range, independantly of the main horizontal scroll bar.

The range is a table from f10:ce25.

Thanks in advance...

 

[Bill_Biggs]

http://www.mrexcel.com/forum/showthread.php?t=359621&highlight=Bill_Biggs

I asked a similar question a few years ago. This was the amazing answer. I bet it will help you. By the way, is it not easy.

 

[repairman615]

Thanks Bill Biggs,
The code looks very complex...you were right.
I was thinking this was a common practice and a no brainer.
Do you know if this code is for a Verticle scroll bar?
I am aiming for a horizontal approach.

Thanks again for the quick response.

 

[Bill_Biggs]

I don't know about the horizontal. This is definitely vertical. You might contact Vladimir (ZVI). He can probably get you going in the right direction. I am sorry I could not be of more help.

 

[the_original_invisible]

This might help you

http://www.yousendit.com/transfer.php?action=batch_download&batch_id=VGljUGhldzgxUURIRGc9PQ

Lee

 

[repairman615]

Roundabout,
Found this very interesting...However my table is made up of conditional formating that uses a formula. Esentially the cells have no data in them.
So in that case I dont believe I could make that work. Getting closer now. Many thanks for your helpful post