I have 20 toggle buttons and I only want one true at any time. I can do this with 20 lines of code setting them all to false but I'm looking to do it with a loop. This is what im trying to do but its saying "togglebutton" is not defined. Not sure how to get it to workl
then use a similar code to select togglebutton2 and have 1 and 3-20 turn off
Please Login or Register to view this content.
Last edited by kevinu; 05-10-2018 at 12:32 PM.
Why not use Option buttons? That's their default behavior.
Entia non sunt multiplicanda sine necessitate
I tried but option boxes are way too small when I zoom out to where the page is useful. I can change the text size but the button itself is way to small. Unless you know how to make the button bigger?
Hello kevinu,
What is your actual objective? Maybe you could consider doing it via a Userform?
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
I'm have a program that can view 20 different EEG scans. By clicking on a button your telling the program which data your wanting to work with. I have a separate load button that looks to see which button is toggled then loads the data to the location for that number... so if 1 is pushed it loads data to sheet1.. if 2 then sheet2 and so on. Its basically a glorified option button so the real program knows where to put stuff. I just cant get the option button to work because its soo small and hard to click.
I havent used userform before but I'll look into that some. Right now I'm just using a sheet with buttons and toggles as a userform of sorts.
Why not use a scrollbar linked to a cell to choose the row of interest?
it would work its just more cumbersome. Its easier with how its set up to just click a button. It actually works now i just have a longer code and was curious if i could use a loop to untoggle the button instead of 20 lines saying togglebutton1.value = false, togglebutton2.value = true. etc.
found this that works partially... but every time it changes a toggle it activates that buttons code
Please Login or Register to view this content.
Last edited by kevinu; 05-10-2018 at 03:43 PM.
Please Login or Register to view this content.
Thanks that works great.. I'll keep looking into user form as well.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks