MrExcel.com - Your One Stop for Excel Tips & Solutions

excel vb - pressing a button to add to a cell incrementally

Posted by josh on November 13, 2001 4:48 PM

I would like to create a function so that when i have a cell that has a value of 1%, when I press a button, the value in that cell increases by .01

Posted by Juan Pablo on November 13, 2001 4:57 PM

Sub Increase01()
ActiveCell = ActiveCell + 0.01
End Sub