OPTION GROUP IN VBA CODE

[Mikmik]

In my main Form I have created an Option Group with 3 Option Buttons having Option Value 1, 2 and 3.
How can I test, in VBA code, which button has been selected by the user?
Any help will be very appreciated.

 

[DerekAOE]

In the Change event of the group's frame, add :

Msgbox MyFrame.Value

This should give you the number corresponding to the Option you selected whenever you click an option button.