Sorry

If i put this formula =IF(G415,PromptPayment(),"")

with this UDF in a regular code module:

Public Function PromptPayment()
MsgBox "Please issue Prompt Payment Letter"
End Function
it comes up with the following error #NAME?

can anyone please help


" wrote:

Hi

me again

When i put any of these formulas in it comes up with an
circular reference error?? Any ideas.

thanks

-----Original Message-----
One way:

=IF(G415,"Please Issue Prompt Payment Letter", "")

If you want a message box instead, use

=IF(G415,PromptPayment(),"")

with this UDF in a regular code module:

Public Function PromptPayment()
MsgBox "Please issue Prompt Payment Letter"
End Function

If you're unfamiliar with UDFs, see David
McRitchie's "Getting Started
with Macros and User Defined Functions":

http://www.mvps.org/dmcritchie/excel/getstarted.htm



In article <010CA17D-1E0C-460D-A366-
,
"Monty" wrote:

if i wanted a message to appear on screen (saying
please issue prompt payment
letter)if a certain number in a cell was over 15.
how would i go about this.
i am a novice at this any help please.
.