• 1
Austin

How do I make a year-button data validation in Excel?

Question

Beatrice writes:

I have a question, I know how to do a data validation drop down but I need the one list with two buttons in the same cell and a range of years.Do you know how to do this?

I work for the school district and they need a particular calendar. They have a cell where you can list the year but it list whole number with a range of 1999 to 2999 and has two buttons.... one to go up in years and one to go lower... Hope this makes sense

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 1

Sure do!

This function you are describing is called a "Spin Button" in excel. There are also two-types of Spin Buttons: Form, or ActiveX.

A Form Spin Button is easier to use, but an Active X can be customized more.Here's how to add them:

1: First, enable the developer Ribbon in Microsoft Excel.detailed instructions here
2: On the developer tab,click Insert > Spin Button (form control).

alt text

3: Click on the location in the document that you want the up/down buttons to appear. They are not locked into cells so you can move and resize them freely.

alt text

4: Make sure the spin button is selected, and then click Properties on the ribbon.

alt text

5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in.

alt text

Hope this helps!

Share this post


Link to post
Share on other sites
  • 2

Sure do!

This function you are describing is called a "Spin Button" in excel. There are also two-types of Spin Buttons: Form, or ActiveX.

 

A Form Spin Button is easier to use, but an Active X can be customized more.Here's how to add them:

1: First, enable the developer Ribbon in Microsoft Excel.detailed instructions here

2: On the developer tab,click Insert > Spin Button (form control).

alt text

3: Click on the location in the document that you want the up/down buttons to appear. They are not locked into cells so you can move and resize them freely.

alt text

4: Make sure the spin button is selected, and then click Properties on the ribbon.

alt text

5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in.

alt text

Hope this helps!

 

This is EXACTLY what I needed. You're my new hero. Thank you sooo much.

Share this post


Link to post
Share on other sites
  • 0

Sure do!

This function you are describing is called a "Spin Button" in excel. There are also two-types of Spin Buttons: Form, or ActiveX.

 

A Form Spin Button is easier to use, but an Active X can be customized more.Here's how to add them:

1: First, enable the developer Ribbon in Microsoft Excel.detailed instructions here

2: On the developer tab,click Insert > Spin Button (form control).

alt text

3: Click on the location in the document that you want the up/down buttons to appear. They are not locked into cells so you can move and resize them freely.

alt text

4: Make sure the spin button is selected, and then click Properties on the ribbon.

alt text

5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in.

alt text

Hope this helps!

 

Great solution!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • By Steve
      Question from Reader - Email Form
       
       
      Hi Tom,
       
      Ouch. I know how it feels losing a days worth of work. The worst part is when you have to recreate what you've already done.
       
      To answer your question, when you found the Entry "OutlookSecureTempFolder" what was the path in the DATA column? I assume you reviewed this post here to find it. It looks like you found the registry key entry so your more than 1/2 way there. Find that key again and you should have the path to your OLK folder and your Excel should be sitting there.
       
      Now the path might be a bit confusing because with Outlook 2007, there actually is "NOT" an OLK folder. For instance, on my XP/Outlook 2007 install, my OLK folder or "Temp Outlook Folder" / "OutlookSecureTempFolder" is:
       
      "c:\Documents and Settings\mrgroove\Local Settings\Temporary Internet Files\Content.Outlook\4V32TZLP"
       
      So if you look on your box you will find what your looking for in the "Content.Outlook" folder. Take a look there and your golden.
       
      Let me know how this works for you!
  • Who's Online   0 Members, 0 Anonymous, 9 Guests (See full list)

    There are no registered users currently online