Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
using 2 different IF statements
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="isabelle, post: 7394987"] hi Tonso, If Application.CountA(Range("c3:c8")) = 6 Then a = 1 Else a = 0 If Application.CountA(Range("j10:J21")) = 12 Then b = 1 Else b = 0 r = "" & a & b Select Case r Case "01": MsgBox "Incomplete Header Information", vbInformation Case "00": MsgBox "All Questions must be answered Yes/No", vbInformation 'you can add another case "10" End Select -- isabelle Le 2012-01-05 09:15, Tonso a écrit : [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
using 2 different IF statements
Top
