Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with radio button | Excel Discussion (Misc queries) | |||
radio button help | Excel Worksheet Functions | |||
"RADIO BUTTON" | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |