Togglebuttons - Changing state based on state of the others

Hi all,

I am looking for some guidance on how to use toggle buttons effectively. Perhaps what I want to do can't be done with toggle buttons, or there may be a more appropriate control to use.

I currently have 3 toggle buttons. At any one given time, only one can be in a TRUE state. So, when the user presses one button setting it to true, the other remaining two must be put in a FALSE state.

Please Login or Register  to view this content.

This is what I started with. It caused catastrophic problems, putting Excel into an unrecoverable crash. I think it was put into an eternal loop with each change in toggle state changing the toggle state of the others and so on.

Can anyone suggest a way to effectively toggle the values of these controls in their different combinations.

My userform initializes these as:

Please Login or Register  to view this content.

I have used mbevents coding to suppress control events during userform initialization in the past. The state of mbevents at the start of the initialization is false, meaning any control changes are executed during initialization. When mbevents = true, the current control change is suppressed with 'if mbevents then exit sub'

I'm not sure if this the approach or not, as I have yet to make it effectively work with my trials.

Which controls are you using? If you use option buttons this is done automatically.

Hi Stephen ... I was using a series of toggles buttons. I had thought about using the option buttons, but find that I am bound to their size (can't adjust them). Trivial, but they don't suit the userform as well as the buttons do.
I'll look into how they work. If I have no other choice, then this is likely the route I'll have to go.

Thanks for your suggestion!

Don't think I've ever even noticed toggle buttons before! Does this do what you want?

Please Login or Register  to view this content.

You could give this a try:-

Please Login or Register  to view this content.

Thank you all for your support ...

StephenR ... I'm thinking that much of your suggestion was the basis of my initial attack which had disastrous consequences. Some weird errors like "Stack overflow" etc which eventually led to a full Excel crash. But yes, this is kinda where i'd like to go with this avoiding the option buttons (which I did get to work!) if possible.

MickG ... I'm playing with the code you provided. It's providing accurate results, but unsure now how to adapt it further.

What your code does is simply change the button caption ... if that button was pressed, it displays true, the other display false.

What I need it to do is depress when true, and then open up a 2nd userform.
I'm not sure really where to go now ...

I made these changes ....

Please Login or Register  to view this content.

Interestingly, when I break the code on the mousedown lines and step through the code, the selected buttons remain depressed. But when I remove the breaks and run the code without interruption or manual stepping, the buttons don't depress.
?????? huh ??????

Hopefully its working for you !!!
Regrds Mick

Ahhh! Mick! Nice ... !

Thank you .... I think you found the winner!

Thank you everyone for your contributions. You support is really appreciated.

You're welcome