Excel Property Differences

[polly316]

Can someone please explain the folowing to me in simple terms.

What are the differences between Excel form controls and Macros?

Also what is the difference between Data Restriction and data validation?

 

[aeurix]

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.).