Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Spinner command (Excel XP)

    Can you give me an example of using the Spinner command from the Forms section? I can't find it in any of the books, nor in much useful information in Help.

    I put
    Bob Wall

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spinner command (Excel XP)

    Hi Bob,

    Tell me what you have in mind for the spinner.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Spinner command (Excel XP)

    I have no idea what Spinner does. I played with the button, but I can't get it to do anything. What does Spinner do? How would I use Spinner?
    Bob Wall

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spinner command (Excel XP)

    Bob,

    I don't know if you mean the spinbutton on a userform or on a spreadsheet. I am not using XP (but XL2000). In the attached spreadsheet you should go to the VBA section to see a Userform with 2 spinbuttons. Each of the spinbuttons has next to it a textbox. One spinbutton can be used to increase or decrease a number in the textbox next to it (from 1 to 99), the other spinbutton can be used to go from A to ZZ, by clicking the arrows of the spinbutton.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spinner command (Excel XP)

    Hi Bob,

    Spinner is a control with two buttons, an Up button and a Down button.

    Click on the Spinner on the Forms toolbar, then click on the Excel sheet and drag it to the size you want.
    While the 'handles' are still showing, right-click on it and select Format Control. This allows you to set the upper and lower limits of the counter, the value by which each click of a button increases or decreases the return value.

    And, you can select the cell where the result (return value) will be dumped.

    One way you could use it is to select a month (1-12) and then use the return value as a parameter for a cell formula. See attached file.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spinner command (Excel XP)

    Not entirely sure why my jpg didn't attach, but I think hans already provided you with an example.
    Attached Images Attached Images

  7. #7
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spinner command (Excel XP)

    A spinner is an up-down control where you can control the range and the increment. See attached example. Can you get it to fail? I can, and can't easily fix it. Spinners are a pain to program. HTH --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  8. #8
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Spinner command (Excel XP)

    I now have enough information to play around with it to see how it works. I thank all of you for your help.
    Bob Wall

  9. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spinner command (Excel XP)

    Bob, rereading your posts, I notice that you said "Spinner command from the Forms section." You may want to use the Controls toolbar instead of the Forms toolbar. You will have more options then. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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