Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validate a result
Can someone correct my macro please cos I'm soooooo close?
Been working on this sheet for days now and starting to get punch drunk! I have borrowed this off the site but cannot adapt it to my needs. I wish to validate a result in a cell and display a msgbox once I have gone over a target figure. The macro Private Sub Worksheet_Calculate() If Me.Range("o16").Value 5000 Then MsgBox "too high - do something!" End If End Sub Works great once I get to over 5000 But i want it to pick its own maximum total from the sum of d27:i27 instead of 5000. How do I adapt this macro to do this as all I keep getting is syntax errors Thanks to all Cheers Nobby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
excel | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions |