+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting and warning notifcations

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Anaheim, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Conditional Formatting and warning notifcations

    Hi and thank you to anyone that might help me.

    And I apologize if this topic has been discussed already (maybe someone can send me a link to it)

    I was wondering if I could have an excel form not be able to close and have a warning notification show if the user has not filled in the form correctly. In other words, I have several fields conditionally fomatted and if they don't fill in all the fields before trying to close the form it lets them know.

    Is this possible?

    Namaste

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,927

    Re: Conditional Formatting and warning notifcations

    Write a Workbook close event that checks the cell that should be filled. Use Cancel to cancel out of the closing and select the sheet and cell.
    Ben Van Johnson

+ 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