I am trying to add a spinner but when I go into format control the control
section is not available and hence I can't link my control to the worksheet.
This is the first timeI have used it could anybody help.

Maureen wrote:
I am trying to add a spinner but when I go into format control the control
section is not available and hence I can't link my control to the worksheet.
This is the first timeI have used it could anybody help.


Have you enabled ViewToolbarsForms ?

Bill

Just to add to Bill's response...

There is a Spinner on the Forms toolbar and a Spinner on the control toolbox
toolbar. It sounds like you used the spinner from the control toolbox toolbar.

If you go into design mode (another icon on that control toolbox toolbar), you
can right click on it and select properties. There's a .linkedcell property on
that properties dialog.

(Or just replace the spinner with a spinner from the Forms toolbar.)

Maureen wrote:

I am trying to add a spinner but when I go into format control the control
section is not available and hence I can't link my control to the worksheet.
This is the first timeI have used it could anybody help.

--

Dave Peterson