How do I set up some cells in a spreadsheet to be a required fiel.

[mickiemaggie]

I am creating a spreadsheet that users will use to select furnishings for
homes in a subdivision. I want to have some of the cells be a 'required
field' much like addresses are when one purchases items online. I want the
users to be told after all of their selections whether or not they forgot to
fill in all applicable cells. Can this be done?

 

[Fred]

I'll assume you have a command button to make calculations after all
entries have been made(?), the command button can call a procedure to
check the necessary cells to verify an entry has been made, otherwise,
set the focus to that cell.

Private Sub CheckForEntry()
'Worksheet Cell "C3" requires an entry

If Range("c3") = "" Then
MsgBox "Make an Entry in cell C3"
Range("C3").Select
End If
End Sub