Keep in mind what I said above, regarding ActiveX versatility, which is absent in Forms controls. Regarding the Forms option button questions, you can use a group box from that same Forms toolbar and group each set of 2 yes & no option buttons, and edit the text of the group box to identify whatever significance each set has.
The only thing I wonder is, why bother with Forms option buttons if you have access to the more versatile ActiveX controls. Is there a function call that will tell me what cell the Option Button is in?Īny help would be greatly appreciated.
FORM VS ACTIVEX CONTROLS IN EXCEL HOW TO
If the Option Buttons are ActiveX controls, I can't figure out how to determine in which cell the ActiveX control resides. What I want is for the buttons in D2 to operate independently from E2.) Is there a way to group these buttons when they are form controls?
Yet, Excel will only allow one of those four buttons to be chosen. (As an example, in Cell D2 are Buttons Y and N. If the Option Buttons are form control Option Buttons, I can't figure out a way to have the switching options be only effective for a particular group. an ActiveX control presents different problems. My problem is that using the Option Buttons as a form control vs.
FORM VS ACTIVEX CONTROLS IN EXCEL CODE
And I'd like to use one set of code such that when a user clicks the button, the macro code will be able to figure out what cell the button resides in and act on the column that the button resides in. I'm trying to put some Option Buttons on my sheets and am having some problems I'm hoping you can help with.īasically, I want to put a series of Option Buttons in several consecutive columns, that when a user chooses between Y or N buttons, macro code is called to handle different events for a column.
0 kommentar(er)
