Radio Button
 

Not a very advanced user.
Have a spreadsheet designed to take a date and calculate
3 other dates (using the Workday function). I need help
accomplishing 2 things:

1st. There are 2 radio buttons. One of the 2 should be
selected before the date can be entered for calculation.
I am hoping that if a user goes right to enter the date
an error message will pop up reminding the user to select
one of the 2 radio buttons. I know this can be done with
Data Validation but I'm not sure how. Ideally when the
user enters data into the first date cell if a radio
button isn't selected, the message box will pop up, and
the formulas in the remaining cells will not execute.
How can I do this with data validation? If not with data
validation, then how?

2nd. Once the calculation is done I want the user to
press a command button that clears all of the text and
resets the 2 radio buttons to "unchecked". How do I get
the macro to set the radio buttons to "unchecked"?

Thanks for the help.

Radio Button
 

Just an addition: If I lock the spreadsheet I can't use
the radio bottons. I have them unlocked and the cells
they are in are unlocked but it won't work. Any thoughts?
-----Original Message-----
Not a very advanced user.
Have a spreadsheet designed to take a date and calculate
3 other dates (using the Workday function). I need help
accomplishing 2 things:

1st. There are 2 radio buttons. One of the 2 should be
selected before the date can be entered for
calculation.
I am hoping that if a user goes right to enter the date
an error message will pop up reminding the user to
select
one of the 2 radio buttons. I know this can be done with
Data Validation but I'm not sure how. Ideally when the
user enters data into the first date cell if a radio
button isn't selected, the message box will pop up, and
the formulas in the remaining cells will not execute.
How can I do this with data validation? If not with
data
validation, then how?

2nd. Once the calculation is done I want the user to
press a command button that clears all of the text and
resets the 2 radio buttons to "unchecked". How do I get
the macro to set the radio buttons to "unchecked"?

Thanks for the help.
.