Display error msg when cells left blank

[Guest]

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

 

[Crowbar via OfficeKB.com]

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

Hello

When the commandbutton is clicked that tranfers your data to your sheet you
need to test the textbox items that you want to be filled e.g.

commandbutton1_click()

If textbox1.value = "" then
msgbox "You need to fill in your name"
exit sub
end if

If the textbox contains data then it will be ignored, you may need to repeat
this process if you have more than one box

(e-mail address removed)

 

[Crowbar via OfficeKB.com]

Sorry ive misinterpreted your post, please ignore my answer

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

Hello

try using a validation on the cell

data->validation...