Need VBA code to hide cells if radio button in another cell is chosen

One line of a form has one radio button marked "PARTS DUE DATE". Next cell is a date which is provided by a drop-down calendar. Another cell on the line has another radio button marked "SERVICE DUE DATE" with another cell that is populated by another drop-down calendar.

My question is....how do I hide one date cell when the other radio button is chosen? I don't need a SERVICE DUE DATE if it is a parts order and vice versa. Can anyone help me? I'm a novice at VBA...I know enough to be vewwy, vewwy dangewous.

sqearly

Forms Toolbar radio buttons - make sure both buttons are linked to the same cell.
(right-click > Format Control > Control tab > Linked Cell)

Control Toolbox Toolbar radio buttons - make sure these buttons are in the same GroupName.
(Right-click > Properties > GroupName)


Once these are set properly, you cannot select more than 1 button in the "group". You will have to add VBA to the radio buttons themselves if you wish to hide/unhide specific columns, too. If you need specific help on that, post your workbook.

Sorry to be a bother, but the converter I use to open 2007 files in my 2003 program doesn't leave your vba objects functional.

Can you save your workbook as an .xls file to see if that does the job?

Also, please indicate more precisely cells/objects you're asking for assistance on, that last sentence above left me scratching my head.

Perfect.

In the DatePicker1 Sheet module, find these two events and replace them, or add them if they aren't there:

Please Login or Register  to view this content.

Each of these subs is independent. As long as they're in the correct sheet module, it doesn't matter what order they're in.

That means you added the code without looking to find the "existing" OptionButton6_click macro, that message means you are trying to save a module with more than one macro with the same name. My code was to replace your existing ones.

Originally Posted by from post #6

In the DatePicker1 Sheet module, find these two events and replace them, or add them if they aren't there:

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.