spin button: create multiple cell link

[DavidRoger]

spin1.xlsxHi all,

Would like to create one spin button that can change few cell with one click.

When I create multiple cell link in the spin button,

Example: Enter B1, C1, D1 and E1 in the cell link but unacceptable.

Please refer to attachment for example.

Tried range also same result.

Any idea how to make it work.

It's really safe me a lot of time from clicking multiple spin button.

[LJMetzger]

Hi David,

Instead of trying to link to the spin button, try a formula that references the results of the spin button.

For example, if spin button 4 is referenced to cell E1, and you want the result also in cell A22, then in cell A22 put the formula:

Please Login or Register  to view this content.

Lewis

[DavidRoger]

Hi LJMetzger,

Figure that out but if you use the spin button again the formula will be lose.

Thank you any way.

[LJMetzger]

Hi again,

I apologize for my original answer not working.

I think I was able to do what you want with macros and VBA. You will have to save your workbook as a .xlsm file, because .xlsx can't run macros.

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/

The code I used was actually pretty simple, by referencing the linked cell.
See the attached workbook which is a working copy.

Please Login or Register  to view this content.

Lewis

[DavidRoger]

Hi,

Good to see you again. This time it's working and more opt to spin button 4 without *10.

Thank you a lot.

May I know what the "Option Explicit" for? It's seen alright when I remove that from vba.

[LJMetzger]

I'm glad that it's working.

Your code may work without 'Option Explicit', but it is VERY IMPORTANT.

To prevent typos from ruining days and weeks of work you need 'Option Explicit' at the top of each code module. This forces you to declare every variable. See http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis