Tricky problem in Data validation - Excel 2003
 

I've created an excel file in Excel 2003 for data entry by the bank
users and included some validation like max length, drop-down box, etc.

There are certain columns which are mandatory, how can i enforce that a
cell is not left blank?
How can i force that data entered is numerical only?

Any help will be greatly appreciated.

Thanks,
Sharath


--
smadhuranath
------------------------------------------------------------------------
smadhuranath's Profile: http://www.excelforum.com/member.php...o&userid=36470
View this thread: http://www.excelforum.com/showthread...hreadid=562347

Tricky problem in Data validation - Excel 2003
 

There are certain columns which are mandatory, how can i enforce that a
cell is not left blank?

With a change event:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then '2 for column B, CHANGE as necessary
If IsEmpty(Target) Then
MsgBox "Mandatory!"
Application.EnableEvents = False
Target.Select
Application.EnableEvents = True
End If
End If
End Sub

How can i force that data entered is numerical only?

select say column B,
Validation/Custom/Formula: =ISNUMBER(B1)

Regards,
Stefi