#1
|
|||
|
|||
Option Buttons - linking and control
I'm using Visio 2010 and I've been trying to get multiple option buttons (radio buttons) to work together so as one is selected, the other is deselected, and I haven't been able to get it to work. I tried grouping them, I tried going into the shape properties and typing in a group name, and I've tried adding a frame object and nothing so far has worked.
The other question I have is, can a scratch cell be linked to the button selection, so Scratch.A1 is 1 when selected and 0 when not selected. I don't see anything on the shapesheet for any of the ActiveX controls that corresponds to the button selection. Would this have to be done in VBA? If so, what would the script be to set a scratch cell to the button selection? |
#2
|
||||
|
||||
Where did you find the radio button object? Post a sample document so we can see what you are dealing with.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
I'm on mobile and not at work to get to my computer right now. The option buttons are in the developer tab ActiveX controls, just like Excel.
|
#4
|
|||
|
|||
Update need the same
Did you ever figure this out? I am needing the same issue resolved.
|
#5
|
||||
|
||||
Are you wanting this interactivity to happen when someone views the Visio file in Visio or is the page being exported to a different format for use? If so, I'm assuming you will need vba to code the ActiveX functionality.
Does this thread help track down what you are trying to do. Radio buttons on Visio page | Microsoft Office Forums
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#6
|
|||
|
|||
Quote:
These two thing are what I need. I am using 2019 Pro |
#7
|
|||
|
|||
Still need this. Did you ever figure it out?
|
#8
|
||||
|
||||
It doesn't appear that the ActiveX Option Buttons work the same way in Visio as they do in other Office Applications. ActiveX is pretty old technology that is generally best avoided nowdays and Visio is not really the tool I would be using for interactive forms.
Post a sample document so we can see what (and why) you are trying to achieve and someone may be able to offer a suggestion.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#9
|
|||
|
|||
Quote:
In any case thank you for mentioning forms. Oh and I did find the insert Frame. Didn't help but I did find it. TY edit Yes just a small skim away I found out how to use a form AND still be able to manipulate the page. Linked below to how to make that happen. Again THANX for your help. ShowModal VBA vbModal and vbModeless Last edited by Mouthpear; 01-25-2024 at 02:11 AM. Reason: Adding information |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Control Buttons, Macros, Fill Colors | casualuser | Excel Programming | 1 | 11-06-2017 05:37 PM |
Option buttons for multiple choice questions | ScottishPolarBear | Word | 4 | 12-02-2014 02:23 PM |
Display cells dependent on option buttons | inq80 | Excel | 0 | 09-01-2014 03:40 PM |
Word 2007 Option buttons - transparency | JacobThomas | Word VBA | 1 | 11-02-2011 05:40 AM |
Option Button ( ACtive X Control ) | aligahk06 | Excel | 0 | 11-03-2009 06:36 AM |