Master Spin Button For Multiple Cells Excel

**lqtech** · 08-22-2015, 01:25 PM

I'm just starting to dabble in VBA, but I'm not proficient to even try this yet. I have a spreadsheet that I use the spin button to keep count of work I do during the month. Before, I had attached a separate spin button to each of the cell, but seeing that I have to do this every month, I need something is time saving. I've found info on making a "master" spin button for the entire sheet, however, the codes that I have tried for what is available is not working for me. Can someone help me with creating my "master" spin button. I have attached my spreadsheet that I use.

I appreciate any help given

Lequisha

**AlphaFrog** · 08-22-2015, 01:51 PM

I don't know what cells you want the Master spin button to change, but try something like this. Put the code in the worksheet's code module that has the spin button.

Private Sub MagicSpinButton_Change()
    Range("C2:C4,C7:C9,C12:C14,F2:F4,F7:F9,F12:F14").Value = MagicSpinButton.Value
End Sub

Change the cell references in red to suit.

Master Spin Button For Multiple Cells Excel

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Master Spin Button For Multiple Cells Excel

Re: Master Spin Button For Multiple Cells Excel

Thread Information

Users Browsing this Thread

Similar Threads

Spin button controlling multiple cells???

[SOLVED] Help with Spin Button. Set Spin button starting value based on a text box value

[SOLVED] Spin Button Using Multiple Active Cells

spin button: create multiple cell link

Excel spin button on Userform

spin button in excel

Spin Button:spin cells A7

Bookmarks

Bookmarks

Posting Permissions