Unlike VB, in Excel VBA the option group box isn't - its
a frame, and doesn't have any properties that are set
when option buttons get set.
shame.
One workaoround is to use each option's click event to
save a number into the frame's TAG property - its not
used by anything else usually.
Then in your process, just read th etag value to get the
option.

Patrick Molloy
Microsft Excel MVP

-----Original Message-----
How can I access the group name property for the option
button control
provided on the forms toolbar? As well as the other
porperties of the form
control toolbox?


.