IF + Message box

Hi,

Im looking for some code to say if cell H3 in tab "RC Check" = Check, Msg box "Check Accounts" Appears in Tab "Screen"

Maybe i could put it in a sub and call it at the end of my routine

Thanks
Seamus
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
FernandoFernandesConnect With a Mentor Commented:
ok then.. the VBA code to do so is:
if sheets("RC Check").Range("H3").value = "Check" then
MsgBox "Check Account",VbOkOnly+VbInformation,"Warning Message"
end if

Open in new window

0
 
FernandoFernandesCommented:
do you need it to be VBA or not ?
well... if formulas are ok put in any cell of the sheet "Screen" where you want to see this result:

=IF('RC Check'!H3="Check","Check Account","")

now, if you need VBA code, let us know more details as what's triggering it, and if you want the result to show in a cell or in a messagebox, or in an external txt file, or ... well, you got my point :)

Thanks
0
 
Seamus2626Author Commented:
Thanks Fernando, i need VBA, I will call it through a sub at the end of my report and a message box will be great.

Thanks
Seamus
0
 
Seamus2626Author Commented:
Thank you FernandoFernandes!!
0
 
FernandoFernandesCommented:
:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.