+ Reply to Thread
Results 1 to 4 of 4

Code to verify text box contains data.

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Code to verify text box contains data.

    Im looking for some code to add before the following code to make sure that the text box ItemDescription contains data. If it does then the below code continues on as normal, however if there is no data then it stops the other code from running and displays the error message "Item Description can not be blank'
    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Code to verify text box contains data.

    Try adding this
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Code to verify text box contains data.

    Right at the start put this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Code to verify text box contains data.

    Thank you both.

+ 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. How To Verify a Certain value/text in a cell Exists in another worksheet
    By Famelie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2013, 02:26 AM
  2. Replies: 4
    Last Post: 07-29-2012, 08:54 PM
  3. Verify Text Exists in a Row of Cells
    By cmashburn in forum Excel General
    Replies: 4
    Last Post: 01-27-2012, 07:14 PM
  4. need vba script to verify postal code format
    By gibsongk55 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2011, 03:32 AM
  5. I want to verify data in 2 different worksheets
    By data verification in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2005, 01:05 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