| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Message if user leaves a field blank
Hi,
I have a drop down list based on a question but if a user skips the question and doesn't select from the drop down list and doesn't click in the cell, how can I create an error message so that they cannot leave this field blank? Many thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message if user leaves a field blank
If they don't click in the cell I don't see a way to pop up a message
without some event code. Either selection_change code in the worksheet or.............. You could place some before_save or before_close event code in Thisworkbook module that will pop up a message and cancel the save or close until they fill in the cell. Gord Dibben MS Excel MVP On Tue, 14 Oct 2008 04:25:01 -0700, GillianX wrote: Hi, I have a drop down list based on a question but if a user skips the question and doesn't select from the drop down list and doesn't click in the cell, how can I create an error message so that they cannot leave this field blank? Many thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display error message if a cell is left blank | Excel Discussion (Misc queries) | |||
| Leaving a cell blank when there is an error message - HELP | Excel Discussion (Misc queries) | |||
| Hiding Rows Leaves Labels Blank | Excel Discussion (Misc queries) | |||
| Text File Import leaves a blank row after each line | Setting up and Configuration of Excel | |||
| How to display a blank cell with no error message | Excel Worksheet Functions | |||
Linear Mode
