Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 23rd 18, 07:02 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2018
Posts: 1
Default 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   Report Post  
Old November 25th 18, 11:39 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
button to go to specific tab vdmbqb Excel Discussion (Misc queries) 6 December 7th 08 09:50 PM
Send data from userform to specific cell on specific sheet? JennLee Excel Programming 10 March 10th 07 03:55 AM
Link from a specific Cell in Excel to a specific para. in Word CathyK Excel Worksheet Functions 0 August 10th 06 04:40 PM
Using Button on User Form to save Data to specific Cell?? DarnTootn Excel Programming 2 May 13th 06 03:20 PM
Hyperlink button to a specific cell in excel JayWes Excel Discussion (Misc queries) 1 July 21st 05 11:21 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017