Use Options (forms) to Specify Specific Data Validation List

[cristopulo]

Hello,

Wanted to know if there is a way to use Options (form) button that changes the type of Data Validation List that appears?

Also if there is a way to use the same option button to hide or show certain cells based on the options chosen?

Example:
User chooses A or B using Option (Forms) button.

Based on selection Data Validation A appears or Data Validation List B appears in specified cell.

And if they choose Option A this would show or hide a cell below it.

Would this have to be done using ActiveX controls and programming in the end?

Thanks in Advance!
cristopulo