Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a button to add 1 to a SPECIFIC cell
I am sure this is a really easy one to answer. I am not a programmer and cant seem to figure out this macro formula Here is the formula I am using to add 1 every time I press a button. However what I realized is that it assigns the value to the cell that my cursor is in. I will be using 4 buttons and need to have the values show in specific cells. So I need to modify he formula to display the result in a specifically assigned cell. Can anyone show me where to put this value in the formula.
Code: -------------------- Sub Add1() Selection.Value = Selection.Value + 1 Beep End Sub thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
a button to add 1 to a SPECIFIC cell
Sub Add1()
Range("A1").Value = Range("A1").Value + 1 Beep End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
button to go to specific tab | Excel Discussion (Misc queries) | |||
Send data from userform to specific cell on specific sheet? | Excel Programming | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Using Button on User Form to save Data to specific Cell?? | Excel Programming | |||
Hyperlink button to a specific cell in excel | Excel Discussion (Misc queries) |