Sign in with
Sign up | Sign in
Your question

Excel Property Differences

Last response: in Windows 7
Share
November 18, 2010 9:45:08 AM

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?
November 18, 2010 4:19:49 PM

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