Macro to support Notification of two different numbers

EE Pros,

I'm looking for a macro that notifies a Excel WB User that two numbers are not =. In the attached mock up, the "Imputed Tax Rate", calculated by dividing Income Tax by Net Sales, is different then the "Effective Tax Rate" which is entered as a number in a different cell.

I am trying to notify the user by a text box, a message or "comment" that only shows when the User selects the Effective Tax Rate Cell, or hovers the cursor over it (In the Mock Up, cell M19). The only other conditions are; if the numbers are "=" there is no need to display the notice. If the Income Tax cell is -0- or blank, the Imputed Tax Rate is then also -0- and may be displayed as compared with the Effective Tax Rate.

Hopefully this is an interesting challenge! And as always, "thank you" in advance!

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

I've added a hyperlink to the cell. Now hover over it. I prefer the UserFormNotice-V2.xlsm

0

Bright01Author Commented: 2018-04-24

Martin and Roy, Thanks! Martin, Roy's solution works but not completely to spec. Based on Roy's work, I have refined the ask.

When you put data into the Income Tax cell (E17), and the Effective Tax Rate cell (M19) is not -0- or blank, or if you change the Tax Rate Cell (M19) and the Income Tax cell (E17) is not -0- or blank, and both the Income Tax cell (E17) and the Effective Tax Rate cell M19) are not =, then the alert should be displayed showing both results. Hovering would also be a nice add and could be as good if not better then an alert.... but given Roy's comments, I rethought the ask. Either approach may be workable.

Thank both of you guys for the help.....

J.

0

Bright01Author Commented: 2018-04-24

Roy,

Almost! Love the hover! BUT... the math in the alert box must reflect any change to either cells (i.e. Income Tax ((E17)) or Effective Tax Rate ((M19)).

I was waiting to hear from you. I just need to amend the rules to display the UserForm to match what you have just asked for. The calculation amd message was the hard work. I've added a hover feature, but I'm not keen on it.

Got to go now but I can add the rules for you later. when I get home, I'll be about an hour

I've just remembered that I wrote some code last year that can probably be adapted to act as "comment" It's been a long day but I'll locate it and see how it amends. I'll get back as soon as I can.

0

Bright01Author Commented: 2018-04-24

Roy, your version 2 with the hovering capability is almost exactly what I'm looking for (vs. the UserForm approach). All we need to do is build in the change to the two variables into the hover notice and it will be perfect.

1.) The Imputed Rate and the Effective Rate need to be reversed in the text.
2.) I tried to adjust the form because when you cycle through the different scenarios, the second % is dropped in the Alert1
3.) And finally, if the Imputed Rate and the Effective Rate are =, then the Alert should not fire since they are the same.