Thread: Command Button
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Command Button

Alan -
yes, that works.......... kinda. but the problem the other thread
had, and what i found too, is that i could make it work (& your sub
works) in order only. if you start with togglebutton1 and move
through them, fine, but if you want to go back or jump around, it
sticks at the last one.
but thanks for your efforts!
:)
susan



On Jul 23, 2:37*pm, Alan wrote:
You could place this code behind each togglebutton. Each time a click is
made, it resets the value of all other togglebuttons to false. Put the
togglebuttons in a frame, called Frame1 in this code. Change ToggleButton1 to
the name of each togglebutton as you place the code behind that button.

Private Sub ToggleButton1_Click()
Dim cCont As Control
* * For Each cCont In Me.Frame1.Controls
* * * * If cCont.Name = "ToggleButton1" Then * 'Change this name to each
buttons name.
* * * * * * cCont.Value = True
* * * * Else
* * * * * * cCont.Value = False
* * * * End If
* * *Next cCont
End Sub

Alan



"Cerberus" wrote:
Hey, quick question about toggle buttons if you don't mind. *Is there a way
to put a condition to a group of toggle buttons that says only one can be
selected at a time. *So let's say if we have 10 toggle buttons in a group and
slection A was pressed and then you decide selection C is better for you,
selection A will "pop" back up. *


Sorry to jump in and ask another question on someone elses question. *I
don't know if that goes against some kind of message board etiquette.


"Susan" wrote:


no, that would be a toggle button.
:)
susan


On Jul 23, 8:53 am, randy wrote:
Is it possible to make a commandbutton stay sunken when clicked? *
Thanks- Hide quoted text -


- Show quoted text -