Archive of posts filed under the Modular Code category.

In an userform list all available fonts

Posted by on

The motivation for this tip was to share how to 1) dynamically add controls to a userform 2) respond to events for these controls, and 3) specifically respond to events using a callback procedure that is located in another class module! Since this may come across as a fairly technical topic, this tip utilizes the …

Continue reading ‘In an userform list all available fonts’ »

Ease of reuse of modular code

Posted by on

The primary reason I write modular code is that it is self-documenting, easy to understand, and easy to maintain. A secondary reason is the ease of reuse. One of the comments to my post Two new range functions: Union and Subtract (www.dailydoseofexcel.com/archives/2007/08/17/two-new-range-functions-union-and-subtract/) was a request for code to copy a range from one worksheet to …

Continue reading ‘Ease of reuse of modular code’ »