I would do it by putting the Cell values into variables and testing their
condition, something like this:

Range("C10").Select
A=ActiveCell
Range("F10").Select
B=ActiveCell

If A0 And B=0 Then
MsgBox ("Enter Data In Cell F10")
End If

This would obviously need expanding with some validation of the datafor the
cells, but I think you should get the general idea.

HTH


Neil
www.nwarwick.co.uk

"M3Cobb" wrote:


Can someone help me out with a fairly simple formula?
I want a message to pop up saying " Please fill in the price".

The function needs to say, If C100, and F10=0 then please fill in the
price.

It should be a simple function, but IF AND statements lose me!!


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=389005