A andrewsheldon98 Sep 24, 2003 #1 I Have the number 0 in cell A10 and would like a button to increment this cell by 1 each time i click on it Can some one help.
I Have the number 0 in cell A10 and would like a button to increment this cell by 1 each time i click on it Can some one help.
D Don Guillett Sep 24, 2003 #2 andrewsheldon98 said: I Have the number 0 in cell A10 and would like a button to increment this cell by 1 each time i click on it Can some one help. Click to expand...
andrewsheldon98 said: I Have the number 0 in cell A10 and would like a button to increment this cell by 1 each time i click on it Can some one help. Click to expand...
L L. Howard Kittle Sep 24, 2003 #3 Assign this macro to your button. Change cell address to suit. Range("A1").Value = Range("A1").Value + 1 HTH Regards, Howard
Assign this macro to your button. Change cell address to suit. Range("A1").Value = Range("A1").Value + 1 HTH Regards, Howard