software

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

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.comquot;Donnaquot; gt; wrote in message
...
gt;I am trying to add a functional scroll bar in a cell of my Excel
gt;worksheet.
gt; Is this possible?
It will not allow me to drag the scroll bar.

quot;Chip Pearsonquot; wrote:

gt; Open the Forms command bar and drag the scroll bar on to your
gt; sheet. Right-click it to assign properties.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Donnaquot; gt; wrote in message
gt; ...
gt; gt;I am trying to add a functional scroll bar in a cell of my Excel
gt; gt;worksheet.
gt; gt; Is this possible?
gt;
gt;
gt;

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!!

quot;Chip Pearsonquot; wrote:

gt; Open the Forms command bar and drag the scroll bar on to your
gt; sheet. Right-click it to assign properties.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Donnaquot; gt; wrote in message
gt; ...
gt; gt;I am trying to add a functional scroll bar in a cell of my Excel
gt; gt;worksheet.
gt; gt; Is this possible?
gt;
gt;
gt;

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

quot;Donnaquot; gt; wrote in message
...
gt;I got the scroll bar in the cell but it is not functional. How
gt;do I assign
gt; properties to allow it to scroll the info up and down the cell?
gt; Thank you
gt; for your time!!
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; Open the Forms command bar and drag the scroll bar on to your
gt;gt; sheet. Right-click it to assign properties.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;Donnaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to add a functional scroll bar in a cell of my
gt;gt; gt;Excel
gt;gt; gt;worksheet.
gt;gt; gt; Is this possible?
gt;gt;
gt;gt;
gt;gt;
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,

quot;Chip Pearsonquot; wrote:

gt; Donna,
gt;
gt; Right click the control on the worksheet and choose Format
gt; Control, then choose the Control tab. There, choose a minimum and
gt; maximum value, and enter a cell reference in the Cell Link box.
gt; The value of the control will automatically be placed in that
gt; cell.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt;
gt; quot;Donnaquot; gt; wrote in message
gt; ...
gt; gt;I got the scroll bar in the cell but it is not functional. How
gt; gt;do I assign
gt; gt; properties to allow it to scroll the info up and down the cell?
gt; gt; Thank you
gt; gt; for your time!!
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt;gt; Open the Forms command bar and drag the scroll bar on to your
gt; gt;gt; sheet. Right-click it to assign properties.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Cordially,
gt; gt;gt; Chip Pearson
gt; gt;gt; Microsoft MVP - Excel
gt; gt;gt; Pearson Software Consulting, LLC
gt; gt;gt; www.cpearson.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Donnaquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am trying to add a functional scroll bar in a cell of my
gt; gt;gt; gt;Excel
gt; gt;gt; gt;worksheet.
gt; gt;gt; gt; Is this possible?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;