Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VB question
I have this macro which checks to see if a cell has a value in it, i want
it to carry on and execute the rest of the macro if it has and halt and exit if it hasn't. At present it continues thru and runs the rest of the macro. what I have at moment if ("b32") = ("b999") then msgbox " Please make selection" end if Call normaltarrif end sub Thx all |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VB question
if range("b32") = range("b999") then
msgbox " Please make selection" Call normaltarrif else exit sub end if end sub -- Don Guillett SalesAid Software "HammerHead" wrote in message .. . I have this macro which checks to see if a cell has a value in it, i want it to carry on and execute the rest of the macro if it has and halt and exit if it hasn't. At present it continues thru and runs the rest of the macro. what I have at moment if ("b32") = ("b999") then msgbox " Please make selection" end if Call normaltarrif end sub Thx all |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VB question
if ("b32") < ("b999") then
then msgbox " Bad Value" Exit sub end if Call normaltarrif end sub -- Regards, Tom Ogilvy "HammerHead" wrote in message .. . I have this macro which checks to see if a cell has a value in it, i want it to carry on and execute the rest of the macro if it has and halt and exit if it hasn't. At present it continues thru and runs the rest of the macro. what I have at moment if ("b32") = ("b999") then msgbox " Please make selection" end if Call normaltarrif end sub Thx all |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VB question
Thanks thats sorted it .
"Tom Ogilvy" wrote in message ... if ("b32") < ("b999") then then msgbox " Bad Value" Exit sub end if Call normaltarrif end sub -- Regards, Tom Ogilvy "HammerHead" wrote in message .. . I have this macro which checks to see if a cell has a value in it, i want it to carry on and execute the rest of the macro if it has and halt and exit if it hasn't. At present it continues thru and runs the rest of the macro. what I have at moment if ("b32") = ("b999") then msgbox " Please make selection" end if Call normaltarrif end sub Thx all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Very simple question. | Excel Discussion (Misc queries) | |||
Simple Question | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple VBA question | Excel Programming |