Using MsgBox in Formula

G

guzzy

Hi All,

Just wondering if it is possible to use MsgBox in a Formula (withou
VBA) ie =IF(A1<=10, MsgBox"Order more stock") except when I do it thi
way I get the old Formula error... I thought it be good to use instea
of using conditional formating to change the cell red or without havin
to program it in VBA

Cheers in advance
guzz
 
D

dominicb

Good evening guzzy

No can do I'm afraid - Msgbox is VBA only.

Your alternatives are conditional formatting, or having "blank" cel
contents turn into "Order more stock" when calculated levels becom
critical, using something like the IF statement that you suggested.

HTH

Dominic
 
Top