Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
issue with excel 2003 data import | Excel Discussion (Misc queries) | |||
Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |