CodeJock ActiveX Controls in Excel Workbooks

[bs0d]

Anyone have experience using their ActiveX Controls in Excel?

I've built a workbook using the standard ActiveX controls available from the developer tab directly in a sheet (Windows 7, Excel '13). I have issues with their behavior when viewed at a different resolution, or in Windows 10. Combo boxes will re-size when clicked, text will increase with each action or decrease in size. I've tried programming around it, setting sizes when clicked and setting different sizes on workbook_open depending on the OS version.

In an effort to hopefully avoid all of this, CodeJock controls were suggested by someone and I'm looking to see if anyone else has used them. If I create a workbook with them and distribute to someone else, do they need to register the library? If so, can this be automated? Looking for any insight and advise here. Thanks

 

[bs0d]

Anyone with experience in this, or thoughts? Thanks

 

[Kyle123]

Can't you use form controls on the worksheet instead?

 

[bs0d]

In some cases, I may be able to. However, some of my form controls are grayed-out, and I also have a multipage control; I see very limited options for form controls (like 4 or 5 total).