Simple MSG BOX Help

[vinothsudar]

Hi all,

I have values in Column D : D 20,000.

This column values shold be " Chennai or Delhi or Madurai"

If data not found i need a msgbox "Invalid City"

Please help on that.

 

[somnath_it2006]

Hi,

If you want to restrict to user for entering the wrong value (other than Chennai, Delhi, Madurai) or highlight that cells in which that wrong value exist then you can simply use the Conditional Formatting.

For conditional formatting check below link:

http://www.contextures.com/xlCondFormat01.html
http://www.digitalsurvivors.com/archives/000351.php

 

[vinothsudar]

No :

Already data in the sheet.

i want to just validdate

 

[Steeviee]

Can you use another column?

Say E1=if(or(D1="Chenai",D1="Dehli",D1="Madurai")=true,"","Invalid City")
Then copy down all of your data and this will highlight the problematic rows (You could filter on this also.

 

[krishhi]

hey look at the following code

Sub validate()

Dim i As Integer, j As Integer, s As String
Dim lr As Integer
lr = ActiveSheet.UsedRange.Rows.Count
For i = 1 To lr
    s = Range("D" & i).Value
    If s <> "chennai" And s <> "madhurai" And s <> "delhi" Then
    Range("E" & i).Value = s
   
    End If
    Next

End Sub