diff --git a/‎Examples/15datavalidation.php‎
Lines changed: 24 additions & 2 deletions b/‎Examples/15datavalidation.php‎
Lines changed: 24 additions & 2 deletions
@@ -62,7 +62,15 @@
                               ->setCellValue('A3', "Number:")
                               ->setCellValue('B3', "10")
                               ->setCellValue('A5', "List:")
-                              ->setCellValue('B5', "Item A");
+                              ->setCellValue('B5', "Item A")
+                              ->setCellValue('A7', "List #2:")
+                              ->setCellValue('B7', "Item #2")
+                              ->setCellValue('D2', "Item #1")
+                              ->setCellValue('D3', "Item #2")
+                              ->setCellValue('D4', "Item #3")
+                              ->setCellValue('D5', "Item #4")
+                              ->setCellValue('D6', "Item #5")
+                              ;
 
 
 // Set data validation
@@ -91,7 +99,21 @@
 $objValidation->setError('Value is not in list.');
 $objValidation->setPromptTitle('Pick from list');
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
-$objValidation->setFormula1('"Item A,Item B,Item C"');	// Make sure to put the list items between " and "  !!!
+$objValidation->setFormula1('"Item A,Item B,Item C"');	// Make sure to put the list items between " and " if your list is simply a comma-separated list of values !!!
+
+
+$objValidation = $objPHPExcel->getActiveSheet()->getCell('B7')->getDataValidation();
+$objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST );
+$objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION );
+$objValidation->setAllowBlank(false);
+$objValidation->setShowInputMessage(true);
+$objValidation->setShowErrorMessage(true);
+$objValidation->setShowDropDown(true);
+$objValidation->setErrorTitle('Input error');
+$objValidation->setError('Value is not in list.');
+$objValidation->setPromptTitle('Pick from list');
+$objValidation->setPrompt('Please pick a value from the drop-down list.');
+$objValidation->setFormula1('$D$2:$D$6');	// Make sure NOT to put a range of cells or a formula between " and "  !!!
 
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet