View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Help with Option Buttons and Frame

Thanks

"B Lynn B" wrote:

I don't believe there is a way around having code for each button's event.
However, you can write a separate sub procedure for the one block of code you
want them all to execute the same, then have each button's event just call
that sub instead of repeating it 10 times.

"Ayo" wrote:

I have a Frame with about 10 Optionbuttons. I am trying to figure out a way
such that when I click on any of the option buttons, something is done. I
can't figure out how to do this without having to write 10 of this:

Private Sub OptionButton1_Click()

End Sub

Is there a way to do it all in one procedure instead of 10?

Thanks