Get the value of a control on a worksheet
Posted on 2012-04-10
I have a pair of option buttons embedded on a sheet. They alternate true and false values between each other just as they should.
But, How do I retrieve the value of an option button inside Excel VBA, when the option button is NOT on a form?
NB Neither of them are linked to a cell. The values given to them do however persist through a save/reload, so must be stored somewhere.
I have searched the help, and EE, yet not found the answer to what seems a very simple question. All the examples I have seen assume that a form is being used.
Many thanks in advance.