Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option buttons on excel and macros
Hello
I have a spreadsheet where I have a series of rows and each row has three option buttons which allow the user to select one depending upon status of their project i.e. red, green, amber. When I populate the page with option buttons it will only ever allow one selection on the page which is not what I need! someone suggested a macro needs to be written but I'm a complete novice when it comes to this. Can anyone help please? BTW thank you very much to those who answered a previous query I had, couldn't find my original post to say thank you!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option buttons on excel and macros
In the same commandbar that you got the option buttons from is a Group box.
If you surround the groups of option buttons inside a group box, they will act independently of other option buttons in other group boxes. Any of the option buttons in one groupbox share the "link cell", but each set of group boxes can (should) have its own link cell. HTH Bob Umlas Excel MVP "shezzer_1972" wrote: Hello I have a spreadsheet where I have a series of rows and each row has three option buttons which allow the user to select one depending upon status of their project i.e. red, green, amber. When I populate the page with option buttons it will only ever allow one selection on the page which is not what I need! someone suggested a macro needs to be written but I'm a complete novice when it comes to this. Can anyone help please? BTW thank you very much to those who answered a previous query I had, couldn't find my original post to say thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons in Excel 2000 | Excel Worksheet Functions | |||
selecting using option buttons in excel | Excel Worksheet Functions | |||
Excel Option Buttons | Excel Discussion (Misc queries) | |||
Excel Option Buttons: getting forced choices per row, not per w/s | Setting up and Configuration of Excel | |||
Excel option buttons | Excel Discussion (Misc queries) |