q re macro and function

[FTCA]

Hi All
Can I start a macro in a "IF" Func
e.g

IF ISBLANK(D3), " " , start macro name getweight

i.e
if a certain cell is blank can I use the true response to place a " " (
space chr)
and with the false response can I automatically start
a macro named mymacro?


TIA

 

[FTCA]

or is there a 'onfocus' type command like in access
i.e when the cursor hits a cell , the macro is run then the cursor is
moved to the next cell along ready for input.

TIA