Excel VBA Active X Controls Resize
Posted on 2011-03-17
I typically try to use form controls when ever I can, but due to a few constraints with how the data needs to be structured, I'm forced into using an ActiveX combobox to leverage the 'Linked Cell' property to export the actual value instead of the number of the choice selected.
There are a lot of times when I've used ActiveX controls where they sometimes re-size (larger or smaller) once they've been clicked. I've written code in the past to automatically re-size the object and font, but was wondering if anyone has experienced the same issue and if there's a quick fix or property change that will prevent this.
Any help is appreciated!