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.