Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Bremser
Use the Toolbar "Forms". First insert a Groupbox, as large as needed to insert 3 option buttons. Then add 3 option buttons in the area of the groupbox. When you run a macro use following for each option button: If ActiveSheet.OptionButtons("OptionButton 1").Value = xlOn Then regards reklamo "Bremser" wrote: I'm trying to simply add a selection button next to each of 3 options on a proposal form. Each button should toggle between 'selected' and 'not selected' status. I want to user to be able to click on the button next to their preferred option to indicate their choice. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding button to worksheet to refresh pivot table data | Excel Worksheet Functions | |||
Adding Macro to Button on WOrksheet | Excel Discussion (Misc queries) | |||
Adding a "CLEAR" button to the worksheet | Excel Discussion (Misc queries) | |||
Adding .xla button for Toggle Calculation Button | Excel Programming | |||
Adding tool tip to worksheet button | Excel Programming |