Good evening raw

You haven't told us what your option buttons are called, so again I
will have to generalise a bit with my answer. The code / syntax you
want is:

OptionButton1.Value = True

but obviously, you may have to change the option button names, true /
false etc depending on your sheet set up.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=479640