help with forms buttons in excel 1

[creeker69]

First - this is the greatest site on the Internet! I need help with buttons (added them via VIEW - TOOLBAR - FORMS).

I have 5 buttons across from each other. I f i click one it highlights and the other goes out. This is the effect I want. But, I want another five underneath of these five and want them to work independently of the first five. So, I could have one button darkened in the third row (assuming a3:e3 for example) and have one the other five work as a set in row 4.....

Hopefully I have explained myself well enough to talk with all you experts out there....

Thanks,
creeker69

 

[GlennUK]

I assume you are using radio buttons for this.

To do what you want, ( in that 1 radio button will be selectable of the first 5, and another selectable from the next 5 ), surround each group of 5 buttons with a Group Box.

The Group Box can be drawn by way of using the "Group Box" button on the Forms Toolbar ( 3rd button ).


Cheers, Glenn.

 

[creeker69]

That did it! Thank you very much. A Star to you!