| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a field compulsary before user leaves sheet
Put the following in the worksheet code area:
Private Sub Worksheet_Deactivate() Dim checkRng As Range Set checkRng = Sheets("Sheet1").Range("A1") If checkRng.Value = "" Then Sheets("Sheet1").Activate MsgBox "Please fill in " & _ checkRng.Address(False, False) & "." End If End Sub Hopefully this has not been truncated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Message if user leaves a field blank | Excel Worksheet Functions | |||
| PivotTable with Server Page Field Leaves MS Query Application WindowOpen After Refresh. | Excel Programming | |||
| Cancel of text box leaves sheet unprotected | Excel Worksheet Functions | |||
| I need to auto exit MS Excel when user leaves workbook open over . | Excel Programming | |||
| Making cells compulsary to fill in on a worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
