Results 1 to 8 of 8

A Simple Email Validation Question

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2003
    Posts
    4

    A Simple Email Validation Question

    I have a column full of email addresses and I have been trying to create a macro that simply makes sure each address at least has an @ and . in it to eliminate the number of emails that bounce back.

    I would prefer the macro to either check the range I highlighted or even the specific column since it will always be column A.

    Also it would be ideal if it simply just highlighted the invalid emails. I was hoping this would be an easy fix for macro gurus.

    After getting on the Internet and trying to learn VB and macros, below is what I have but its not working and it is using a message box instead of highlighting since I am not sure how to do that.
    Sub ValidEmail()
    Dim Cel As Range
    For Each Cel In Intersect(Selection, ActiveSheet.UsedRange)
    
      If InStr(1, Cel.Value, ".") = 0 Or InStr(1, Cel.Value, "@") = 0 Then
               MsgBox "Email address not valid"
               bNotValid = True
            End If
            Cel.Value = Cel.Value & ";"
    Next
    End Sub
    Thanks for any help and tips.
    Last edited by cfaust; 12-29-2010 at 06:06 PM.

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