Austin Posted October 22, 2011 Report Share Posted October 22, 2011 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 Link to comment Share on other sites More sharing options...
Austin Posted October 23, 2011 Author Report Share Posted October 23, 2011 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 here2: On the developer tab,click Insert > Spin Button (form control). 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. 4: Make sure the spin button is selected, and then click Properties on the ribbon. 5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in. Hope this helps! Link to comment Share on other sites More sharing options...
beeanalystloveexcel Posted October 23, 2011 Report Share Posted October 23, 2011 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). 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. 4: Make sure the spin button is selected, and then click Properties on the ribbon. 5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in. Hope this helps! This is EXACTLY what I needed. You're my new hero. Thank you sooo much. Link to comment Share on other sites More sharing options...
Steve Krause Posted November 1, 2011 Report Share Posted November 1, 2011 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). 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. 4: Make sure the spin button is selected, and then click Properties on the ribbon. 5: Fill out the values as needed. The cell link is the cell in the spreadsheet they will show up in. Hope this helps! Great solution! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.