+ Reply to Thread
Results 1 to 2 of 2

Msgbox if data is incorrect

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Veenendaal, Nederland
    MS-Off Ver
    Excel 2010
    Posts
    14

    Msgbox if data is incorrect

    Hi guys,

    I'm totally not into VBA. but i'm trying to create a msgbox, which will occur if data is filled in incorrectly.

    Basicly i need the following:

    If the data in D2 has more or less then 10 digits then
    "The data you entered is probably incorrect, the data should be 10 digits."

    I'm not sure if this is possible. Maybe a workaround?

    Thanks in any help!
    Last edited by worecx; 11-02-2011 at 10:35 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Msgbox if data is incorrect

    Have a look at using Data Validation with the Text Length option.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ 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