Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Button vs Command Button Gizmo Excel Programming 2 April 8th 08 08:16 PM
Wanting to Create A Command Button Command bumper338 Excel Programming 3 May 7th 07 06:53 PM
VB's Command Button vs Form's Command Button Ronald Dodge Excel Programming 3 May 24th 06 02:23 PM
Command Button vs Form Button Bri[_3_] Excel Programming 2 February 3rd 06 08:18 AM
Command Button vs Control Button RGibson Excel Programming 1 October 14th 03 02:24 AM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"