Embedding spin button

  • Thread starter Thread starter smcquaid
  • Start date Start date
S

smcquaid

I've put a spin button icon into a cell and liked it to
that cell. However when I go to use the button it
highlights it for editting and won't work. The button
comes up with: =EMBED("Forms.SpinButton.1","") - in the
top panel when selected - do i need to modify this to get
it working
 
Maybe try the spinner from the Forms Toolbar instead of the Control Toolbox?

Here's some steps to ease you in:

Let's say we want to create a spinner button
to increase / decrease the value in say, cell A2

Steps
-------
Click View > Toolbars > Forms

Click on "Spinner" icon in the toolbar ("up/down arrow")

Hold down Alt key and draw the spinner
to fit over say B2:B3
(it will snap to the grid if you hold down Alt)

Right-click on the spinner > Format Control > Control tab
(Accept the default Incremental change, which is "1")

Put inside Cell link: $A$2 > OK

Now click on the up arrow of the spinner
Each click will increment the value in A2 by 1

Tinker around the spinner control - it's quite intuitive..
 
smcquaid,

You are still in Designmode. From the Control toolbox just select the Exit
Designmode (Top left; Triangle+ Ruler+Pencil figure) and press it to exit
it.
Your spinbutton will then work.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top