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