Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button when pressed it will +1 to another field
Customer Survey- When a button or cell is pressed once it will add 1 to
another existing field and every time it is pressed it will add another 1. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button when pressed it will +1 to another field
Private Sub Commandbutton1_Click()
Dim myRange as Range Dim myNumber as Long Set myRange = ActiveSheet.Range("a5") '<== change myNumber = myRange.Value myNumber = myNumber + 1 myRange.Value = myNumber End Sub susan On Nov 24, 9:25*am, mswisher wrote: Customer Survey- When a button or cell is pressed once it will add 1 to another existing field and every time it is pressed it will add another 1.. * |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a button when pressed it will +1 to another field
Might be easiest to add a spinner from the Forms Toolbar or Control
Toolbox.. But a macro to do what you want. Add a button and assign the macro. Sub add_one() With ActiveSheet.Range("A1") .Value = .Value + 1 End With End Sub Gord Dibben MS Excel MVP On Tue, 24 Nov 2009 06:25:03 -0800, mswisher wrote: Customer Survey- When a button or cell is pressed once it will add 1 to another existing field and every time it is pressed it will add another 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter button jumps to next cell each time its pressed!!!! | Excel Discussion (Misc queries) | |||
preventing button being pressed | Excel Discussion (Misc queries) | |||
count how many times a button is pressed | Excel Discussion (Misc queries) | |||
create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
Change button right before the formula field | Excel Discussion (Misc queries) |