| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display error msg when cells left blank
Hello
try using a validation on the cell data-validation... "Jas" wrote: It would be a worksheet change event but the code doesnt seem to work: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Range(C3).Value = "" Then Application.EnableEvents = False MsgBox "This is a mandatory field. Please enter you name." End If Application.EnableEvents = True End sub "Tom Ogilvy" wrote: You will probably need to put code in an appropriate event. Chip Pearson has an overview of the events at http://www.cpearson.com/excel/events.htm look them over and decide when you want to determine if the user has complied. -- Regards, Tom Ogilvy "Jas" wrote: I am creating a form that users have to input (straight on to the worksheet) certain information into. There are certain bits of information that is mandatory and if these are not filled in then I want an error message to appear saying that they have to fill that box in before they proceed. Can anyone help on how I can do this? Thanks! Jas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display error message if a cell is left blank | Excel Discussion (Misc queries) | |||
| #DIV/0! Error - Need to display 0 or blank | Excel Worksheet Functions | |||
| Validating cells left blank | Excel Programming | |||
| PivotTable (blank) cells won't display NULL! | Excel Programming | |||
| How to display a blank cell with no error message | Excel Worksheet Functions | |||
Threaded Mode
