Option box macro needed please!

[Tony]

Hi there,

I have the following issue, which might be best explained with the following
diagram:

A B
1 Holdings Ltd Option box (ie. an Option box from the Control
box menu)
2 West Ltd Option box
3 East Ltd Option box

If you click the Option box in cell B1 then the macro can remember Holdings
Ltd in cell A1 and find it in another sheet.
Similarly, if you click all option boxes then the macro can find Holdings
Ltd, West Ltd, & East Ltd in another sheet.
Also I would like the ability to click on the option button again and
de-select this option.
Hope you can help!
Thanks alot.
Tony

 

[Jim Vierra [661815]]

You want a group of "Check Boxes" and not a group of Options. Options are
mutually exlusive. CheckBoxes are multi-select. You will still have to
decide what event causes the results to be returned - I suggest a "Command
Button" to read the checks and execute the Locate on the second spreadsheet.