Hi
just put some code behind the click event of your command button. Something
like

......
if activesheet.range("A1").value<"" then
if not optionbutton1.value then
msgbox "Error"
end if
end if
....

--
Regards
Frank Kabel
Frankfurt, Germany
"tjb" schrieb im Newsbeitrag
...
When the user clicks a command button, there should be an error message if
data is in cell A1 and one of three option buttons is NOT checked. If no
data is in cell A1 then the option buttons should be ignored. Any
suggestions?