|
Excel sheet scroll bar options
I am trying to add a functional scroll bar in a cell of my Excel worksheet.
Is this possible? |
Excel sheet scroll bar options
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? |
Excel sheet scroll bar options
It will not allow me to drag the scroll bar.
"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? |
Excel sheet scroll bar options
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? |
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? |
Excel sheet scroll bar options
I assigned min a 1 and max at 75. I added the cell and it prompts me with a
Compile error: invalid outside procedure. Then it opens a microsoft Visual Basic screen that I do not know what to do with. Thanks, "Chip Pearson" wrote: 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? |
| All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com