+ Reply to Thread
Results 1 to 5 of 5

Need Help! Mandatory field with two cells, but one of them needs to be filled!

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2010
    Posts
    43

    Need Help! Mandatory field with two cells, but one of them needs to be filled!

    I would like to make mandatory cell that one of the two cells needs to be filled.
    F62 or H62, and if H62 is filled prompt to mandatory cell (B55 to K66) to give explanation!
    I need to put this in already made code!
    Thank you

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: Need Help! Mandatory field with two cells, but one of them needs to be filled!

    So .... show this "already made code"
    probably in the place where you check whether H62 is filled you have to add few lines

    for instance if you have something like (or may be with do ... loop?)
    Please Login or Register  to view this content.
    you could add a part to deal with checking H62 and then if it is not empty - enforcing user to fill additional cells
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Need Help! Mandatory field with two cells, but one of them needs to be filled!

    Hi Kaper,
    I have tried both formulas multiple times, and it seems that they do not do anything!
    Thanks!
    Am I missing something there?

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: Need Help! Mandatory field with two cells, but one of them needs to be filled!

    Which formulas?
    If you mean my code samples - yes this code does nothing the real action shall be in places with comments, like:
    Please Login or Register  to view this content.
    Yeah, you missed (or I see it that way - may be I am wrong) at least two things:
    1) quote from my post:
    So .... show this "already made code"
    2) quote from forum rules:
    Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

  5. #5
    Registered User
    Join Date
    08-22-2013
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Need Help! Mandatory field with two cells, but one of them needs to be filled!

    From xladept
    Please Login or Register  to view this content.
    Works like a charm!
    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mandatory cells if another is filled
    By jdixon825 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 10:32 PM
  2. [SOLVED] How to make it IMPOSSIBLE TO CLOSE Workbook until mandatory cells r nt filled?
    By Scofield24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2013, 05:31 AM
  3. Make several cells mandatory if a cell in a range is filled out
    By steeveho in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2013, 06:49 AM
  4. Mandatory field required message when user skips mandatory fields
    By Bharathi27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 05:12 AM
  5. mandatory cells only if another cell is filled
    By RA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 12:45 PM

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