Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Search a Column for
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Search a Column for
Resolved · Low Priority · Version 2003
Reply 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
For upcoming training course dates see: Pricing & availability
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
Tue 12 May 2009: Automatically marked as resolved.
|