View original (French)

Spinner copy paste button

info2 -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

I would like to know if it is possible to "copy-paste" a spin button that refers to a cell and have the reference of the spin button change automatically.

For example, if a spin button refers to cell A2 and I want to copy this button to A6; is there a way to avoid manually changing the reference from =$A$2 to =A$6, so that it updates automatically?

I’m not sure if I explained myself well, but thank you in advance for your help.
Configuration: Windows 7 / Internet Explorer 8.0

1 answer

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    no, it needs to be redefined manually
    (or by vba if it's the activeX spinner, but still, I doubt you have 30 spinners on the sheet...)

    eric

    You will never respond to an unsolicited private message...
    Well, that’s done.
    0