VBA Code for Check Verification

[thematulaak]

Hi guys I need help with a VBA code for the checks in my models. If the cell is more or less than 0 I would like to highlight it a light red, and if it's 0, light green. In addition to this if the cell exceeds 0 I would like a dialogue box to pop up with "Verify Check". Would appreciate it heaps, thanks.

 

[Marc L]

Hi !​

If the cell

Which one ?‼​

​

Well describe your need in order there is nothing to guess …​

 

[thematulaak]

Thanks! So this is the logic I want to code.

- Current Cell Selection
- Keyboard Shortcut: Cntrl Shift + C
- If more or less than 0 = Light Red
- If 0 = Light Green
- If more or less than 0 = Message Box "Verify Check"

So in essence I want to ensure than when changing the model I am notified when the check does not zero out.