Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

IF + Message box

Posted on 2011-02-16
5
Medium Priority
?
187 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

636 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