Check if any cell in range fulfills required condition

**vandanavai** · 02-03-2008, 05:56 AM

Hello,

Please tell me how to go about this. I want 'Message Box' to appear on screen if any cell in selected range fulfills condition specified in macro vb code.

for example

If I select Range A1:A10
If any cell value in this range exceeds 100 then Msgbox "Cell with > 100 value"
Otherwise no MsgBox.

Any ideas? Please help.

**VBA Noob** · 02-03-2008, 06:02 AM

Maybe

If you want it to stop after the first cell find use the exit for statement by removing the '

Please Login or Register  to view this content.

VBA Noob

**royUK** · 02-03-2008, 07:47 AM

Why do you need VBA to do this, Conditional Formatting could be used to highlight cells matching the condition & wouldn't need macros enabling.

**VBA Noob** · 02-03-2008, 08:29 AM

Originally Posted by royUK

Why do you need VBA to do this, Conditional Formatting could be used to highlight cells matching the condition & wouldn't need macros enabling.

I agree with Roy

VBA Noob

**vandanavai** · 02-03-2008, 11:52 AM

Thanks for help

**TChang** · 04-01-2010, 11:31 AM

Originally Posted by vandanavai

Hello,

Please tell me how to go about this. I want 'Message Box' to appear on screen if any cell in selected range fulfills condition specified in macro vb code.

for example

If I select Range A1:A10
If any cell value in this range exceeds 100 then Msgbox "Cell with > 100 value"
Otherwise no MsgBox.

Any ideas? Please help.

I think if you write the following code in another cell, say A11, it should work. Hope this helps!

=IF(COUNTIF(A1:A10,">100")>0,"Cell with > 100 value","")

EDIT: Oops, I just realized I'm 2 years behind. I'm sure you don't need this anymore, but maybe this will help others!

**aster_da** · 10-05-2011, 03:09 AM

Originally Posted by TChang

I think if you write the following code in another cell, say A11, it should work. Hope this helps!

=IF(COUNTIF(A1:A10,">100")>0,"Cell with > 100 value","")

EDIT: Oops, I just realized I'm 2 years behind. I'm sure you don't need this anymore, but maybe this will help others!

It did help me

Thanks