promt warning msg if value in cel "" is below value in cell ""

[shilpz]

hello

i wanted to know if there is a way which i can so that would tell excel if a certain cell value is lower then another it would give a msg
for example

Cell A1 - 5
so if cell A2 is less then five and a macro is clicked then the macro would give a warning msg hence ending the macro

thanks in advance

[MickG]

Hi, something like:-

Dim oNum As Integer
 For oNum = 1 To 5
     If Cells(oNum, "A").Value < 5 Then
         MsgBox "Range " & Cells(oNum, "A").Address & " Value is < 5"
    End If
Next oNum

Regards Mick

[shilpz]

as i mentioned in the previous post that if

Cell A1 - 5
so if cell A2 is less then five and a macro is clicked then the macro would give a warning msg hence ending the macro

i meant the other way round sorry so if

Cell A1 is 5 then
if A2 value is more then 5 then a warning message will comeup and when the macro is clicked it will give a warning message sayin "macro cannot continue"
but keeping in mind that Cell A1 can change anytime therefore it is not a specific range

sorry for the annoyance
thanks in advance

[VBA Noob]

mind that Cell A1 can change anytime therefore it is not a specific range

Can you confirm what you mean. Is it A1 the activecell or what

VBA Noob

[MickG]

Hi I'm not totally clear this what you want, but this code will present a msgbox, and exit the Macro, if any value between "A2" to "A5" is greater than the value in "A1". I assume you meant the value in "A1" could change not the location Address.

Dim oNum As Integer
 For oNum = 2 To 5
     If Cells(oNum, "A").Value > Range("A1").Value Then
         MsgBox "Range " & Cells(oNum, "A").Address & _
         " Value is > " & Range("A1").Value & vbNewLine & _
         "     ""Macro Ended"""
         End If
Next oNum

Regards Mick

[royUK]

Why use code when Data Validation can do this?

[shilpz]

hello

i am sorry i dident really explain my problem properly before i have created a example spreadsheet of what the prodblem is can you please help me solve it

thanks in advance