|
You may want to use Option buttons in MS Excel when there are a small number of options from which to choose. Option buttons are added by using the Forms toolbar. If the Forms toolbar is not visible, right-click on a toolbar and in the resulting shortcut menu, select Forms. Follow the steps below to learn how to add these buttons to your worksheet: - From the Forms toolbar, click and drag the Option Button to place it in your worksheet.
- Select and delete the text in the box.
- While holding down your ALT key, drag the Option Button to the appropriate cell.
- Select the Option Button in edit format and right-click.
- From the resulting shortcut menu, select Format Control.
- Select the Control tab.
- In the Cell link box, type the reference of the linked cell, the name LinkNumber.
Pay attention to the order in which you copy Option Buttons and paste them into the sheet. The linked call, LinkNumber, will return the value of the Option Button according to the order in which it was pasted from the Form toolbar. That means that the first button will return the number 1 to the linked cell. The second button pasted will return the result 2 to the linked cell, etc. When you add two more Options Buttons to the sheet, both buttons will automatically be updated with the linked reference upon being pasted into the sheet. Therefore you do not need to update these buttons with the reference of the linked cell.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
-- Related newsletter articles:
2007/03/01 Create a Toolbar Button for Any Action: MS Word (toolbar)
2007/02/22 Wrist Watch to be Replaced by Hybrid Phone (cell)
2007/05/30 T-Mobile Wing Features Latest Windows Mobile OS (cell)
2008/01/30 Selecting Text in MS Word (button)
2006/02/10 Remove Winfixer (Removal Instructions) (button)
2006/05/18 Remove SpywareQuake (Removal Instructions): Simplified (button)
2007/01/31 Use GoTo to Locate Text in a Document: MS Word (button)
2007/08/21 Open a Web Page from a Toolbar in MS Office (button)
2007/02/28 Customize a Toolbar with Readymade Buttons: MS Word (buttons)
2007/06/21 iPhone Onscreen Keyboard Sparks Debate (button)
2007/01/09 Windows on the Road: MS Teams Up with Ford (cell)
2008/02/08 Popular Judge Interrupts Court Proceedings (cell)
2007/12/24 Cell Phones and Drivers Don't Mix in UK (cell)
2007/02/20 Record and Run a Macro in MS Word (button)
2007/11/09 Keep Word Commands Handy With Office 2007's Quick Access Toolbar (button)
2007/09/14 Teens Banned From Using Cell Phones? (cell)
2007/05/08 Latest Defense in Homeland Security: Cell Phones? (cell)
2007/12/20 Cell Phone Comes With an $83,000 Service (cell)
-- Recent articles (from all channels): 2008/05/15 Today in History: for Thursday, May 15, 2008
2008/05/15 [ShellX 20080515]: 'Commercial Games Released As Freeware', and '
2008/05/15 Outside Company Offers Smarter Wikipedia Searches
2008/05/15 Microsoft-Google Battle Goes Galactic
2008/05/15 Find it Over and Over Again in MS Word
2008/05/15 Hackers Find A New Hiding Place for Rootkits
2008/05/14 [ShellX 20080514]: 'Blend', and 'Dexpose2'
2008/05/14 Windows XP Service Pack 3 Gives Boot to HP, AMD Machines
2008/05/14 Stephen Colbert Among 'Webby' Winners
2008/05/14 Irony Strikes At Tech Conference
2008/05/14 Getting Closure in MS Outlook
2008/05/13 [ShellX 20080513]: 'Drive Spacio', and 'Youtube Batch Downloader'
2008/05/13 Congressman Calls For Second Life Ban In Schools
2008/05/13 Trying to Exit MS Excel 2007
2008/05/13 Problems Reported With Windows XP SP3
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
|
