Dear All,
How to use active x Option Button programmatically.

Please assist ?

Rgds,
Aligahk06

There are entire chapters of books written on how to use option buttons.
You will need to be more specific about what you want to do with an option
button.

Private Sub OptionButton1_Click()
MsgBox "This is one way"
End Sub



"Aligahk06" wrote in message
...
Dear All,
How to use active x Option Button programmatically.

Please assist ?

Rgds,
Aligahk06

Show the Control Toolbox toolbar. Select command button and draw ti on your
spreadsheet. Double click the button you just drew and you will be taken to a
code stub in the VBE where you can write your code...

Return to XL and exit design mode...
--
HTH...

Jim Thomlinson


"Aligahk06" wrote:

Dear All,
How to use active x Option Button programmatically.

Please assist ?

Rgds,
Aligahk06

I have an excel workbook that contains active x option button.
I want to see the code for option button.
the sheet is not protected.
can anybody assist how can i look the code for option button.

Please assist ?


"Jim Thomlinson" wrote:

Show the Control Toolbox toolbar. Select command button and draw ti on your
spreadsheet. Double click the button you just drew and you will be taken to a
code stub in the VBE where you can write your code...

Return to XL and exit design mode...
--
HTH...

Jim Thomlinson


"Aligahk06" wrote:

Dear All,
How to use active x Option Button programmatically.

Please assist ?

Rgds,
Aligahk06