How Radio Control Works
Im becoming very frustrated with Excel. Im working with radio buttons from the Forms control box.?
I cant make them not be independent. Grouping doesnt do anything and I cant use check boxes. I have two columbs with about 30 radio buttons in each. I want to be able to tick only one radio box in each row but multiple in the columns. No idea how to do this. If you provide email I can send you the document I am working on. Been 2 hours now
If you are using the Forms toolbar without success, try using the Control Toolbox toolbar (ActiveX).
Here is how to do it.
Activate the Control Toolbox toolbar from View > Toolbars.
Create two option buttons on the worksheet.
Size and position them over the first row/columns.
Right click on the first and select Properties.
When the Properties window opens, scroll down to Group Name. It will probably read ‘Sheet1′ or whatever sheet number is active.
Change the value to ‘Row1′ (no quotes), or whatever your first row is. Repeat for the second option button in that row.
With both option buttons having the same group name, they will now operate independently of all other groups.
Repeat the process for each ‘set’, using the row number as the Group Name property.
Note: When done you will have to exit Design Mode on the Control Toolbox toolbar by clicking the triangle, ruler, and pencil icon (far left). To re-enter Design Mode, click the same icon again.
|
|
Mickey Mouse Clubhouse: Mickey’s Numbers Roundup – DVD with Mickey Mote $18.88 Includes the episodes “Mickey’s Roundup,” “Daisy Bo-Peep,” “Mickey’s Big Surprise,” and “Super Goof’s Super Puzzle.” Also includes a “Mickey Mote” remote control. 96 min. total. Standard; Soundtracks: English Dolby Digital stereo, French Dolby Digital stereo, Spanish Dolby Digital stereo; Subtitles: English (SDH), French, Spanish; bonus episode…. |
|
|
Linksys EA4500 App-Enabled N900 Dual-Band Wireless-N Router with Gigabit and USB $199.99 The Linksys EA4500 Maximum Performance Dual-Band N900 Router features 4x Ethernet ports for allocating fast signals to your connected PCs and Wi-Fi 802.11n for establishing a high-performance wireless network. It uses dual-band technology to get rid of interference from other wireless devices for smoother network performance; use its USB 2.0 interface to share data over your network…. |
|
|
Syba SD-CM-UAUD USB Stereo Audio Adapter, C-Media Chipset, RoHS $6.98 Description:Upgrade, replace, or fix desktop/laptop sound in a minute.Features: USB Stereo Audio Adapter, RoHS Compliant with USB 2.0 Full Speed (12Mbps) Specification Compliant with USB Audio Device Class Specification 1.0 Compliant with USB HID Class Specification 1.1 USB bus-powered mode, no external power required. Connectors: USB Type-A, Stereo output jack, Mono microphone-input jack LED indi… |
|
|
Logitech S150 USB Speakers with Digital Sound $8.88 Light pact design for portability Satellite base designVolume mute LED indicator controls2″ dynamic drivers90Hz 20kHz frequency responseNo batteries required3-year limited warranty… |
|
|
Blue Microphones Icicle XLR to USB Mic Converter/Mic Preamp $59.00 Why should you bother with a bulky interface, when all you want to do is plug a single microphone into your computer? With a Blue Icicle in your arsenal, you can turn any microphone into a totally streamlined, USB-ready recording device. Instead of lugging around some fancy rack and a bunch of outboard gear, just toss an Icicle and a mic in your laptop bag, and take your studio straight to the sou… |
|
|
Spot ”Micro Mouse” Radio Controlled Mouse Cat Toy $17.39 Grab the controls & watch your kitty go crazy for this remote controlled mouse! You literally drive the mouse with the controller and watch your cat chase after it!!!… |
