ExcelBanter - View Single Post

Don Wiss

On Fri, 23 Dec 2005, "Dennis I" <Dennis wrote:

Question for Leith Ross. I too was looking for help on finding a frames
control and was pleased to read your reply. Now I have put in a frame as you
have suggested and added some controls (option buttons). But I cannot find a
way to use the events from those buttons. How do I capture an event related,
say, to OptionButton1 in Frame1?

All Option Buttons have a linked cell. All buttons within the same group
share the cell. It will have a value of 1,2,etc. The default is all buttons
on a sheet are in the same group. Frames will allow more than one group on
the same sheet. The linked cell can be found on the properties sheet. You
can also have the clicking fire a macro. For a Forms button you give it the
name of the macro to run. So more than one button can call the same macro.
For a Controls button the macro will be unique for each button and resides
behind the sheet. To start the macro click view code.

Not sure if this answers your question, as I'm not sure of the question.

Don <www.donwiss.com (e-mail link at home page bottom).