Key Points

• Use a spin control to choose between a small range of numbers, and a scroll bar to choose between a large range of numbers.

• Use a combo box control to select an item from a list. If the list has multiple available columns, use the BoundColumn property to determine which one the combo box returns.

• Use the UserInterfaceOnly argument for the Protect method to protect a work-sheet while giving your macros special privileges.

• Use event handler procedures to allow ActiveX controls to change protected cells.