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