View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sam[_8_] sam[_8_] is offline
external usenet poster
 
Posts: 17
Default How to count optionbuttons on specific range on worksheet

HI,

I know the method to count the option buttons(From form toolbar) on one
worksheet as follow:

Worksheets("Sheet 1").OptionButtons.Count

Now, I want to count option buttons on specific range on worksheet,
like range"D10:F15"

I used the following code:

Worksheets("Sheet 1").range("D10:F15").OptionButtons.Count

However, it doesn't work.

Do you have some ideas about this issue? which clause should I use?
Thank you inadvance!!!


Best Regards

Sam