control objects

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

If I want to put a spin button (up and down arrows) next to cell A1 to
change, say numbers from 0 to 9. I found out how to put buttons but
they don't do anything. Now I guess I need to write some assignments
to them. How do I do that? Do I need to know VBA or it's simpler then
that? can somebody help please

Mark
 
Hi Mark

If you use a Spin Button from the Forms toolbar no code is needed.
Simply add to the sheet, size, then right click and choose "Format
Control" then "Control".

Post back if you get stuck.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
Click to expand...


Yep, I got stuck.
I placed this control button next to A1, I followed your instruction
but when I go "Format Control" then you said "Control" and I don't
have it (Control I mean) I get a window with four tabs:
Size, Protection, Properties, Web and there is no Control option
anywhere.
Something is bothering me:
You said I don't need any code, but how do those buttons know what I
want to control? I think I have to tell them somehow, right?
So how do I do that? Where do I put the data that I want my spin
button to display, whether they are numbers, names etc.
I did what you said and when I exit design mode and click on those
buttons nothing happens
thanks Dave

Mark
 
Mark: Go into the VB Editor (Alt+F11), then go to Help (F1), and type
SpinButton Control in the Index.

HTH
Ed
 
Mark,

It sounds as though you've used a spinner from the Control Toolbox instead
of the Forms Toolbar. If so, you can right-click the spinner, choose
Properties, and put your cell address in the Link Cell box. Now take it out
of design mode (button on Control Toolbox). This spinner has many
advantages over that from the Forms toolbar, one being that it's less likely
that the user will manage to select it and move it. But it's not as
straightforward to use.
 
Back
Top