+ Reply to Thread
Results 1 to 2 of 2

Validate Values for all columns in a row

  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    50

    Validate Values for all columns in a row

    Is there a method to ensure that a user cannot leave a specific row (via carriage return or mouse click) until all cells within that row are populated with a data value

    I want it to act similar to a web form (in such that it can't be submitted without having all the required fields entered)

    An error message would be triggered when the user attempts to abandon the row

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Maybe something like this will work for you. Right-click on the sheet tab, select View Code, and copy the following:

    Please Login or Register  to view this content.
    If the columns you want to be completed are contiguous, simply change the column numbers (variables iFirstCol and iLastCol above in red) to suit your needs. If they are not contiguous, then post back, and I can manipulate the code to work for you.

    HTH

    Jason

+ 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