+ Reply to Thread
Results 1 to 4 of 4

linking spinner and button entries

  1. #1
    BG
    Guest

    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. #2
    Gord Dibben
    Guest

    Re: linking spinner and button entries

    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" <spam.check@spamcheck.com> 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. #3
    BG
    Guest

    Re: linking spinner and button entries

    Many thanks Gordon.

    BG



  4. #4
    Gord Dibben
    Guest

    Re: linking spinner and button entries

    Thanks for the feedback.

    Gord

    On Tue, 27 Sep 2005 19:03:19 +0100, "BG" <spam.check@spamcheck.com> wrote:

    >Many thanks Gordon.
    >
    >BG
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1