Excel icon

Excel worksheet interactivity with ActiveX controls

Using the Control Toolbox we can create interactive worksheets without any VBA whatsoever.

Continue Reading: Excel worksheet interactivity with ActiveX controls »

Excel icon

Clear out all controls on a form

Problem: you have a userform and need a way to quickly reset all of its controls. The code needs to be self-scaling, so you don't have to remember to update it every time you add or remove a control from your form.

Continue Reading: Clear out all controls on a form »

Site last updated: February 8, 2012