Seamus2626
asked on
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
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
ASKER
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
Thanks
Seamus
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you FernandoFernandes!!
:-)
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