+ Reply to Thread
Results 1 to 2 of 2

VBA Mandatory Fields before submitting worksheet to email address

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy VBA Mandatory Fields before submitting worksheet to email address

    Looking for advanced help with Excel/VBA. I am creating a catering form that a user will fill out and submit. There are three different sheets in the workbook and the user may only need to fill out 1 or 2 of the sheets at a time. On each worksheet, there is a submit button (that through VBA) sends the completed form to an email address.

    In each worksheet, there are mandatory fields. I want to ensure all fields in the specific sheet are filled before hitting the submit button but I am unsure how to code the "once they hit submit, ensure these fields are filled out"

    I can do it so that it prompts to fill in the fields before saving or closing the excel document, but I cannot figure out the "beforesubmit" option.

    Any ideas? I can provide the document and code if need be

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA Mandatory Fields before submitting worksheet to email address

    Hello lisbradley,

    Welcome to the Forum!

    It would help if you could post the workbook. You don't say what your fields are. I will assume they are specific cells on the worksheet.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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