Form Controls VS Active X Controls..

[clickdraw]

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

[#2]

Jeff,

Please follow this link 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.

[#3]

Thanks for the response. So for using an "Index" formula, best to use the form control rather than activex...?

[#4]

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.

[#5]

Thank you again. Have a great day Haytham.

Cheers,

Jeff