Thread: Counter button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Counter button

'View' 'Toolbars' 'Forms'
In the box that appears, click 'Button' (second down on the right) then
click in the worksheet.
In the box that appears click 'New'
Underneath 'Sub Botton1_Click' enter:-

Range("A1") = Range("A1") + 1

Press Alt and F11 to close the window.
Change A1 to suit and you can rename the button by right clicking it.

Regards,
Alan.

"Dennis" wrote in message
...
How would I go about coding a command button to advance a number in
another
cell by 1 each time the button is clicked, like a counter?