The way to manage option buttons is to use the Group name,
the same name for all buttons in a group. Then clicking
one will 'unclick' the one previously clicked. Set one up
as a default (Value Property). To control the Click
Unclick (there is no unclick event in a group as it is
controlled by the click of another option button) add code
to the .Click event

If you just want something to click and unclick the try a
toggle button or a normal Command button that changes the
Caption each time it is clicked ?
-----Original Message-----

I believe you should go to the 'GroupName' property.

I am having the same problem as you are. I am trying to
set up my
Option Buttons in VB, so I can use the 'GroupName'
property, but I do
not know how to program the Click / Unclick.

HELP!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.