How-To Geek on MSN

3 must-know custom data validation formulas for preventing errors in Excel

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
TechRepublic

How to run a VBA procedure from a data validation control in Microsoft Excel

How to run a VBA procedure from a data validation control in Microsoft Excel Your email has been sent There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at ...
How-To Geek on MSN

How to use the FORMULATEXT function in Excel

The simplest use of the FORMULATEXT function is straightforward formula auditing.
EDN

Excel: Using the Validate Data Feature

I began writing this series of blogs on Excel for Microcontroller Central. When it was shut down, Brad Albing (then editor of Planet Analog) agreed to copy the existing database across as a base for ...
TechRepublic

How to use UNIQUE() to populate a dropdown in Microsoft Excel

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.
Royal Society of Chemistry

2-day In-person Seminar on Validate Your Own Excel Spreadsheet Application – Workshop at San Francisco

This seminar will improve your Excel skills and create a set of validation documents that you can use for subsequent Excel application and other Commercial Off-The-Shelf (COTS) validation projects.