I am creating a form in Excel 2013 using activeX controls. I use VBA code to resize the rowheight to shrink and grow the areas that have more detail. So if you check the checkbox beside a category, it opens up and unhides the controls associated with it. Basically more check boxes and labels, as well as a text box for the "other" field.
The checkboxes have unique names and captions. When I check the checkbox it opens up the row to show the checkboxes, but only about half of them can be checked. The ones that can't flash briefly further down the page, but won't check. The text boxes won't take data either.
If I go into design mode and move the check box slightly, then get out of design mode they will work. Until I shrink the row with the associated checkbox, then when I expand it, they stop working again.
The only thing I noticed is that the "top" property for the checkbox has a value that is duplicated on other checkboxes. When I move it around in design mode, it changes, but after the problem recurs, it is back to it's original duplicate value.
Here is a sample of the vba code I use to change the row height:
You can see in the attached file screenshot, where the outside lab services checkbox has an errant check box below it. That ONLY appears when the mouse button is held down clicking on the Other checkbox above it that is clicked and it never unchecks.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.