Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

マイクロソフトはExcelの新機能として従来の「Data Types」を拡張した、「Custom Data Types」の導入を明らかにしました。

To create a custom list, click the cell in which you want the list to appear. Click "Data Validation" on the Data tab and click "Data Validation." Choose "List" in the Allow box.

I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...

Duplicate entries may be valid -- but when they aren't, they can derail your summaries and totals. Use Excel's Validation feature to reject duplicate entries.