Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
I'm looking for a macro to be halted if the value in a cells is less than a
certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
with Worksheets("Sheet3")
if isnumeric(.Range("C1")) then if .Range("C1").Value < 10 then msgbox "Halt Who goes there; number less than 10" Exit sub end if Else msgbox "Halt Who goes there; no number in C1" exit sub End if End With ' continue to process -- Regards, Tom Ogilvy "John" wrote in message ... I'm looking for a macro to be halted if the value in a cells is less than a certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
Thanks for the code Tom
"Tom Ogilvy" wrote in message ... with Worksheets("Sheet3") if isnumeric(.Range("C1")) then if .Range("C1").Value < 10 then msgbox "Halt Who goes there; number less than 10" Exit sub end if Else msgbox "Halt Who goes there; no number in C1" exit sub End if End With ' continue to process -- Regards, Tom Ogilvy "John" wrote in message ... I'm looking for a macro to be halted if the value in a cells is less than a certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
Tom
I wish to remove the message "msgbox "Halt Who goes there; no number in C1", just want the one dialog box, but I can't work out my If's from my with's "John" wrote in message ... Thanks for the code Tom "Tom Ogilvy" wrote in message ... with Worksheets("Sheet3") if isnumeric(.Range("C1")) then if .Range("C1").Value < 10 then msgbox "Halt Who goes there; number less than 10" Exit sub end if Else msgbox "Halt Who goes there; no number in C1" exit sub End if End With ' continue to process -- Regards, Tom Ogilvy "John" wrote in message ... I'm looking for a macro to be halted if the value in a cells is less than a certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
If C1 will always contain a number
with Worksheets("Sheet3") if .Range("C1").Value < 10 then msgbox "Halt Who goes there" Exit sub end if End With -- Regards, Tom Ogilvy rg "John" wrote in message ... Tom I wish to remove the message "msgbox "Halt Who goes there; no number in C1", just want the one dialog box, but I can't work out my If's from my with's "John" wrote in message ... Thanks for the code Tom "Tom Ogilvy" wrote in message ... with Worksheets("Sheet3") if isnumeric(.Range("C1")) then if .Range("C1").Value < 10 then msgbox "Halt Who goes there; number less than 10" Exit sub end if Else msgbox "Halt Who goes there; no number in C1" exit sub End if End With ' continue to process -- Regards, Tom Ogilvy "John" wrote in message ... I'm looking for a macro to be halted if the value in a cells is less than a certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt A Macro If a Cell Contains a Certain Value
Thanks Tom, I get totally confused with the number of if, end if, with etc,
no matter what I take-out / remove it always seems to hit debug "Tom Ogilvy" wrote in message ... If C1 will always contain a number with Worksheets("Sheet3") if .Range("C1").Value < 10 then msgbox "Halt Who goes there" Exit sub end if End With -- Regards, Tom Ogilvy rg "John" wrote in message ... Tom I wish to remove the message "msgbox "Halt Who goes there; no number in C1", just want the one dialog box, but I can't work out my If's from my with's "John" wrote in message ... Thanks for the code Tom "Tom Ogilvy" wrote in message ... with Worksheets("Sheet3") if isnumeric(.Range("C1")) then if .Range("C1").Value < 10 then msgbox "Halt Who goes there; number less than 10" Exit sub end if Else msgbox "Halt Who goes there; no number in C1" exit sub End if End With ' continue to process -- Regards, Tom Ogilvy "John" wrote in message ... I'm looking for a macro to be halted if the value in a cells is less than a certain figure, with a dialog box informing the user appearing Cell with value is C1 and anything less than 10, should halt the existing Macro I have, with a Dialog box appearing showing "Halt Who goes there" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Halt Rest of Macro after Error €“ Jim Cone review | Excel Discussion (Misc queries) | |||
"No RETURN() or HALT() function found on macro sheet." | Excel Worksheet Functions | |||
No RETURN() or HALT() function found on macro sheet | Excel Discussion (Misc queries) | |||
Halt all code while macro runs | Excel Programming | |||
Code to halt a macro | Excel Programming |