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

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

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

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