Excel Property Differences

Form controls are something you do on the worksheets themselves, Macros are visual basic code you can write (or record) using the developer tools. Form controls are considered easier to new users, and Macros are a bit more complex.

Data restriction will prevent users from entering information into cells that are locked. Data validation will force a certain type of format for the cell (number,letter,date, etc.).