Hi,
my name is henry. I want to ask how to access a value in Excel option button
which is using xlformcontrol.xloptionbutton
which the value i want to show in textbox as information.

i've coding :
msgbox excel.xlformcontrol.xloptionbutton
and it displayed number 7 which the const of xloptionbutton
what i want is the value inside the optionbutton not the const.

does anyone know the answer?
thank's in advance