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. |
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.. * |
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. |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com