Forum Discussion
Form Controls VS Active X Controls..
Morning Everyone,
Continuing on my price quote form. So far, I've used "form controls" option button. I can't adjust the font size or type but in the "ActiveX Controls" option button, I can. What are the Pro's and Con's to each? How can I change the cell link from displaying True or False and have it display the button number so I can use that number in an Index formula?
Thank you,
Jeff
4 Replies
Jeff,
Please follow this https://support.office.com/en-us/article/Overview-of-forms-Form-controls-and-ActiveX-controls-on-a-worksheet-15BA7E28-8D7F-42AB-9470-FFB9AB94E7C2 to learn more about Form Controls and ActiveX Controls.
With regard to change the cell link from displaying True or False, you can't change it, it's either True or False, that represents the state of the control.
Thanks for the response. So for using an "Index" formula, best to use the form control rather than activex...?
Of course, because some of the Form Controls provide you with the index number of the input so you can use it inside INDEX function.
