Mandatory fields

[Neilf01]

I am wondering how/if i can make a field in excel (2007) a mandatory field so that a date has to be entered into it?

 

[Neilf01]

Moonfish - also getting error that says "can't execute code in break mode"

 

[moonfish]

This is the basic formula:

=IF(AND(ISBLANK(H2),COUNTA(A2:G2)>0),1,0)
                ^            ^
                |            |
   This refers to the date   |
   of the first entry.       |
                             |
                This refers to all the other
                cells that can be filled in
                for the first entry.

As long as these references are correct, the formula should work.

As for your second error, here's a page about it: http://support.microsoft.com/kb/177828

 

[Neilf01]

Hi Moonfish, it doesn't help that i am not great at anything on computers (apologies). The formula on the spreadsheet is great adn thats fine (as it tells me when the field is empty etc). The problem (i think) is with the macro as when i run the macro is states "compile error, methos or data member not found" I have inoput the macro code as below

Private Sub CommandButton1_Click()
If SaveAsUI = False Then
If Me.Worksheets("sheet1").Range("J2").Value > 0 Then
Cancel = True
MsgBox ("Save cancelled. Please fill in all the required fields and try again.")
End If
End If
End Sub

Does this look spot on to you or am i missing naything that should be on there. (the top line "private sub..., is already pre written by excel as are the final end if and end sub)

 

[moonfish]

You're not supposed to put it in a button, it's an automatic check.

It should prevent anyone from saving the file if the data is incomplete, but only if you use it exactly as I posted it earlier.