Howdy,
I've searched the non-existent documentation in Excel, tried the internet and what books I had but cannot find the answer.
In Access, I can create an option group, and then that group will have an attached value based on which button is chosen, which I can then use in a case statement or in other creative ways.
In Excel, I've created an option group with a groupname, but I can't find anyway to access this value. If it doesn't exist then how do you make the decisions in code without checking every option button?
I've searched the non-existent documentation in Excel, tried the internet and what books I had but cannot find the answer.
In Access, I can create an option group, and then that group will have an attached value based on which button is chosen, which I can then use in a case statement or in other creative ways.
In Excel, I've created an option group with a groupname, but I can't find anyway to access this value. If it doesn't exist then how do you make the decisions in code without checking every option button?