Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Form Button vs Command Button | Excel Programming | |||
Wanting to Create A Command Button Command | Excel Programming | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming | |||
Command Button vs Control Button | Excel Programming |