Solved

IF + Message box

Posted on 2011-02-16
5
180 Views
Last Modified: 2012-05-11
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
Comment
Question by:Seamus2626
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 34907453
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
 

Author Comment

by:Seamus2626
ID: 34907520
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
 
LVL 6

Accepted Solution

by:
FernandoFernandes earned 500 total points
ID: 34907620
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
 

Author Closing Comment

by:Seamus2626
ID: 34908143
Thank you FernandoFernandes!!
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 34908156
:-)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question