Hello everyone,

I'm new here, but was hoping I could get some help with a date calculator I am trying to create. I am using excel 2003, and the problem I am facing is that the active x controls I used to create the form on my home computer are not active on my work computer.

What I would like to accomplish is allow the checkbox on the form change the radio button set to a specific option when the checkbox is checked. In other words, when the check box is checked only one option will be available in the radio button set, and if that option is not selected then the radio button will switch to that option.

Does anyone know how i can do that in excel 2003 without making use of active x form controls.

A thank you to all those who respond.