Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

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
Avatar of FernandoFernandes
FernandoFernandes
Flag of United States of America image

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
Avatar of Seamus2626

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
ASKER CERTIFIED SOLUTION
Avatar of FernandoFernandes
FernandoFernandes
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you FernandoFernandes!!