View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Excel sheet scroll bar options

Donna,

Right click the control on the worksheet and choose Format
Control, then choose the Control tab. There, choose a minimum and
maximum value, and enter a cell reference in the Cell Link box.
The value of the control will automatically be placed in that
cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Donna" wrote in message
...
I got the scroll bar in the cell but it is not functional. How
do I assign
properties to allow it to scroll the info up and down the cell?
Thank you
for your time!!

"Chip Pearson" wrote:

Open the Forms command bar and drag the scroll bar on to your
sheet. Right-click it to assign properties.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Donna" wrote in message
...
I am trying to add a functional scroll bar in a cell of my
Excel
worksheet.
Is this possible?