Msgbox Optionbutton1.Value

But it will show True or False, that is set or not.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"henry" wrote in message
m...
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