Summary

This chapter explained some of the differences between ActiveX controls embedded in worksheets and Form controls embedded in worksheets, and you've also seen how to work with them. You have seen how scrollbars, spin buttons, checkboxes, and option buttons can be used to execute macros that can harness the full power of VBA and that do not need to depend on a link cell.

In addition, this chapter demonstrated how Form controls and ActiveX controls can be created and manipulated programmatically. ActiveX controls are more difficult to create programmatically, because they are contained within OLEObjects and you can't create their event procedures in advance.

0 0

Post a comment