VBA Code to add numbers when a button is clicked

**ISUCyclones** · 06-14-2012, 12:08 PM

I am not very good with writing VBA code so I'm looking for some help.

I want to have a button in an Excel document (using a Macros) that when the user clicks the button, it adds 6 to a certain cell (F5). Then each time it is clicked, it keeps a running total.

Is there any simple code that can do this for me?
Thanks for your help!

**tigeravatar** · 06-14-2012, 12:16 PM

ISUCyclones,

Welcome to the forum!
Something like this should work for you:

Sub Macro1()
    
    Range("F5").Value = Range("F5").Value + 6
    
End Sub

**ISUCyclones** · 06-14-2012, 12:24 PM

That works perfect for what I need. Thanks for your help Tigeravatar!

**SirRyanGiggs** · 06-14-2012, 12:25 PM

This should work and to add a keyboard shortcut to your macro go to options enter your shortcut then click ok.

Sub adding()
Dim x As Integer
x = Cells(5, 6).Value + 6
Cells(5, 6).Value = x
End Sub

Any time you click that shortcut it should repeat the operation

VBA Code to add numbers when a button is clicked

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA Code to add numbers when a button is clicked

Re: VBA Code to add numbers when a button is clicked

Re: VBA Code to add numbers when a button is clicked

Re: VBA Code to add numbers when a button is clicked

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions