Hi,

can anybody tell me how I can insert into the comment of the cell from
which a vba Function is called a message ?

Example:

VBA custom Function: GetPrice(Date As String; ProductCode As String)
Say that in cell A1 I put: =GetPrice("01/02/2005";"AAAX001")
I would like the function to return the price if available or write
into the comment the explanation of an error (if any)

Thanks in advance

Paolo

From Italy


--
kayard
------------------------------------------------------------------------
kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716
View this thread: http://www.excelforum.com/showthread...hreadid=542097