Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking spinner and button entries
I'm trying to achieve a dual way of incrementing the contents of a cell
using the spinner and / or buttons from the forms toolbar. Example - Cell B1 contains the number 5 spinner increments the entry by 1. Cell now contains the number 6 Button then increments same entry by 1 each time it's clicked (4 clicks). Cell now contains the number 10. Spinner works OK, Being a novice (especially to macros) I'm now struggling to get the button to work. I can get it to increase by 1 (using another cell for the result) but it only worlks once because cell B1 remains constant. Can anyone help please? Thanks. BG |
#2
|
|||
|
|||
BG
Sub go_up() With Range("B1") ..Value = .Value + 1 End With End Sub Gord Dibben Excel MVP On Mon, 26 Sep 2005 22:03:31 +0100, "BG" wrote: I'm trying to achieve a dual way of incrementing the contents of a cell using the spinner and / or buttons from the forms toolbar. Example - Cell B1 contains the number 5 spinner increments the entry by 1. Cell now contains the number 6 Button then increments same entry by 1 each time it's clicked (4 clicks). Cell now contains the number 10. Spinner works OK, Being a novice (especially to macros) I'm now struggling to get the button to work. I can get it to increase by 1 (using another cell for the result) but it only worlks once because cell B1 remains constant. Can anyone help please? Thanks. BG |
#3
|
|||
|
|||
Many thanks Gordon.
BG |
#4
|
|||
|
|||
Thanks for the feedback.
Gord On Tue, 27 Sep 2005 19:03:19 +0100, "BG" wrote: Many thanks Gordon. BG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spinner Button - Incremental Change | Excel Discussion (Misc queries) | |||
Spinner Button Reset | Excel Discussion (Misc queries) | |||
Spinner Button properties | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |