+ Reply to Thread
Results 1 to 2 of 2

check if multiple text boxes are empty

  1. #1
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    check if multiple text boxes are empty

    What I need is some code to check if a few text boxes are empty, if the text box is empty then a message box should pop up that displays all which text boxes are empty and afterwards aborts the rest of the code.

    example:

    Company name: (Blank)
    Brand name: (Blank)
    cost: (Blank)

    after hitting submit a text box should pop up and inform the user that the above data is missing and stop the rest of the code from executing.

    below is the code I have however it does not stop the data that eventually gets added from being added to the spreadsheet
    Please Login or Register  to view this content.
    rest of the code

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: check if multiple text boxes are empty

    Hello,

    Probley not the prittiest way of going about it though it should work.
    Please Login or Register  to view this content.
    hope it helps

+ 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