+ Reply to Thread
Results 1 to 2 of 2

Tricky problem in Data validation - Excel 2003

  1. #1
    Registered User
    Join Date
    07-18-2006
    Posts
    1

    Question 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

  2. #2
    Stefi
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1