Using Shapes as Option Buttons

Thanks 6string for both offering an alternative, pointing out the useless code, and fixing the code tags. I attempted to upload an example document (I didn't see it anywhere in the post), but then tried to remove it, due to it having information in the file properties that I'm not sure I want to post. I'm really fumbling around on this site and VBA adventure as a whole.

I haven't messed with the option button yet, but I'm assuming I won't be able to customize the appearance any more than an activex toggle button. I have a working document using the toggle buttons already (the option button would have been nice to know about a week ago), but they don't look good enough for my report. I really want to use shapes.

If you can post a file with the sensitive properties removed I can help move you along with what you have. But it would take me too much time to re-create your situation from scratch.

If you went through the upload process but the file didn't show up it may be that it's too big and you didn't see the message (has happened to me many times). For some reason, we allow zip files that are much larger than .xlsx files, so you might try to zip it then attach it.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Ok. I tried to attach an example to the OP and now sending on reply in a zip folder. I don't know how much it will help, but hopefully it will because I gave it a pretty good go at trying to figure this out myself.

The first tab shows what I need the shapes to be capable of, but using toggle buttons. The other tab shows the format I want the shapes. I think I'm going to rename the thread to "treat shapes as option button" because it seems like that is really the case.

I also updated your title, but I'm not sure why you weren't able to.

I couldn't change the title due to the link to the rules in the moderator's note. I removed the link, so I could change the title to SOLVED! This looks like exactly what I needed. I will have to play with it quite a bit using it in my report, but I think I have all the tools I need now. Really thank you, this helped a ton.

-James

Gotcha, I will get better with the rules. Thanks for fixing the mistakes

Originally Posted by jwright2

Gotcha, I will get better with the rules. Thanks for fixing the mistakes

NP. We try to be gentle on noobs.

Haha we need that. I just re-read the rules and since this is elaborating, I don't think I'm breaking the new help request rule (#4). I have added a third shape button (Red) and noticed if you click the button that is currently selected, all of the other data will show. Is there a way to make all items hidden, or auto select a certain button, if all buttons are turned "off"?

To illustrate the problem, you can open the attached Excel. Blue is currently "on" the other two are "off", click blue. Now green and red are showing. Now if you click (unselect) green, both blue and red will show. This seems fixable, but nothing I can think of has worked.

You can't just add more buttons and replicate code; I gave you a two-button solution. The logic needs to be different for more than two buttons. If you click on one button, the logic sets the state of the other button to the opposite. But if you extend this to three buttons, and click on a button to turn it off, you turn the other two on and you don't want more than one one at a time.

The way option buttons work is if you click one that is Off, it turns On, and the one that is On turns Off. If you click on one that is already On, nothing happens. Is that the model you want to follow with your shape-buttons?

Yes, I believe that model will work, as long as I can choose which buttons are tied to each other. My plan is to have multiple shapes as a menu, which are used to select (unhide) which columns of data you see. Then in these columns have a shape or two which will unhide rows to show additional features, so for the shapes that control these rows I would need the associated column button to stay On when the row button is selected On.

I did try to change the code to a structure similar to my original togglebutton code, thinking I could get all of this to work, but I couldn't. You were right about shapes not being easy for a beginner. If I wasn't clear enough, let me know and I will post an example, or try to clarify better.