• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 3
  • 2
1 Solution
 
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
 
FernandoFernandesCommented:
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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now