Sun 3 May 2009, 15:15Delegate Daren said...
Daren has attended:
Excel VBA Intro Intermediate course
Search a Column for
I have a list of FALSE/TRUE statments in cells E37 to E48 from 12 tick boxes
I need to display a message box, only if all the cells are FALSE
How would write the routine
Tue 5 May 2009, 16:36Trainer Anthony said...
RE: Search a Column for
Hi Darren. The simplest way to do this would be to use the COUNTIF function in a piece of VBA code placed in the Worksheet module. COUNTIF will check whether you have 12 "TRUE" values and then display a message box.
Something like this:
If Application.COUNTIF(E37:E48, "TRUE") = 12 Then
MsgBox prompt = "This is my message alert""
Hope this helps,
Anthony
