+ Reply to Thread
Results 1 to 2 of 2

Make Cell Mandatary To Select

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Virar, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Make Cell Mandatary To Select

    Hi Team,
    I have one example.
    PFA Excel file.
    Question?
    In this example I have four form elements, all are drop-down list.
    I want to make the first two select box as mandatory.
    Like: 1. If no value selected for all select boxes - OK
    2. If Only Mandatory select boxes selected - OK
    3. If non-mandatory select boxes selected and mandatory select box values are blank - Error

    Please provide the solution.
    Thank!
    Mandar.
    Attached Files Attached Files

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Make Cell Mandatary To Select

    You can put the conditions for error in the Workbook_BeforeSave event and prevent the 'saving' until conditions met, like

    Please Login or Register  to view this content.
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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