Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
is there a way to create a button in your spreadsheet which completes a
single command. Ie add 3 to a cell over and over so it just keeps increasing everytime you push the button |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sure.
Open the VB editor (Alt F11 or similar). Menu Insert Module. Paste this into the module: Sub Add3() Range("C14").Value = Range("C14").Value + 3 End Sub Return to Excel. Show the Forms toolbar if it's hidden (View menu). Put a button from it onto the worksheet. Rightclick the button. Choose Assign Macro, assign Add3 to it. Voila. HTH. Best wishes Harald "pts" skrev i melding ... is there a way to create a button in your spreadsheet which completes a single command. Ie add 3 to a cell over and over so it just keeps increasing everytime you push the button |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button commands or hyperlinks | Excel Discussion (Misc queries) | |||
command button commands to much | Excel Discussion (Misc queries) | |||
DOS commands | Excel Discussion (Misc queries) | |||
Help with "if-then"/look up commands or what ever you think is best. | Excel Discussion (Misc queries) | |||
MS DOS Commands | Excel Programming |