LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PaulW
 
Posts: n/a
Default Rotating Scroll Bar

I currently have a form that I want to have 2 Scroll bars, one Vertical and
one Horizontal. Using the Forms toolbar I can easily make a scroll bar and
assign whatever I want to it fairly easily.
The problem is that the Rotate option is grayed out so I can't have a
Horizontal bar, only vertical ones.
These bars are going to be used to pin point a specific cell in an array,
and im currently using =INDEX() based on two bars, then in the array using
conditional formatting to highlight the cell that is currently being used.
But i'm currently having to use 2 Vertical scroll bars instead of one of
each, which is not very tidy.

Any help would be appriciated. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll horizontaly with mouse, create same system used to scroll . frederic New Users to Excel 5 October 9th 05 08:15 PM
Scroll the screen view with the scroll bar avbs Excel Discussion (Misc queries) 1 June 25th 05 04:43 PM
Mouse scroll jumps from up/down to left/right Chris Excel Discussion (Misc queries) 0 April 15th 05 05:48 AM
How do I restrict any one not to scroll more than 100 row? Saadi Excel Worksheet Functions 1 January 7th 05 07:25 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 05:39 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"