R
randy
Is it possible to make a commandbutton stay sunken when clicked?
Thanks
Thanks
S
Susan
no, that would be a toggle button.
susan
susan
C
Cerberus
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.
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.
R
ranswrt
Thanks I new it was an easy answer.
Susan said:no, that would be a toggle button.
susan
S
Susan
ha ha the thread's been hijacked! no i don't think it's an
issue.............
anyway, i thought that if a group of toggle buttons is on a userform &
you put them all in a frame, then they might behave as option buttons
& only one can be selected...... but no, you can select them all.
so whether they're in a userform or if they're on a spreadsheet & you
want the behavior you described, you would have to CODE it that way,
by using grouping or tags - each time one was selected, you'd loop
through all the others & make sure they are all "false" or "true",
whichever you want.
if typeof ocontrol is msforms.togglebutton and
ocontrol.tag = "Group" then
ocontrol.value = false
end if
something like that.
hope it helps!
susan
issue.............
anyway, i thought that if a group of toggle buttons is on a userform &
you put them all in a frame, then they might behave as option buttons
& only one can be selected...... but no, you can select them all.
so whether they're in a userform or if they're on a spreadsheet & you
want the behavior you described, you would have to CODE it that way,
by using grouping or tags - each time one was selected, you'd loop
through all the others & make sure they are all "false" or "true",
whichever you want.
if typeof ocontrol is msforms.togglebutton and
ocontrol.tag = "Group" then
ocontrol.value = false
end if
something like that.
hope it helps!
susan
S
Susan
wow, this is harder then you'd think. because when you go to set the
other toggle buttons to false, it triggers the click event
again.......... i'm going round & round with boolean values & trying
to figure out the logic. i'll betcha there's something simple i'm
missing (application.enableevents=false doesn't work with userforms)
but i haven't found it yet.
susan
other toggle buttons to false, it triggers the click event
again.......... i'm going round & round with boolean values & trying
to figure out the logic. i'll betcha there's something simple i'm
missing (application.enableevents=false doesn't work with userforms)
but i haven't found it yet.
susan
C
Cerberus
Sounds do-able... Would I have to put that CODE in evey Toggle Click or would
one do the trick. Thanks for the help Susan.
one do the trick. Thanks for the help Susan.
S
Susan
just to close out the thread, here's another thread that discusses the
problems i was having & the the solution they came up with.........
http://groups.google.com/group/micr...l=en&lnk=gst&q=togglebuttons#9ccfefba2518a42f
ultimately the solution they came up with was to go with something
different, because they couldn't make it work very easily!
susan
problems i was having & the the solution they came up with.........
http://groups.google.com/group/micr...l=en&lnk=gst&q=togglebuttons#9ccfefba2518a42f
ultimately the solution they came up with was to go with something
different, because they couldn't make it work very easily!
susan
C
Cerberus
That sucks, I have 32 different toggle buttons with a "paint sample" on each
one of them. Oh well
, live and learn huh. Thanks for looking into that
for me though.
one of them. Oh well
, live and learn huh. Thanks for looking into thatfor me though.
A
Alan
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
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
S
Susan
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
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