Documentation for RCHCreateComment() function


Description

    Creates a comment box for the cell that can contain text and/or an image (e.g. a stock chart).

Syntax

    =RCHCreateComment( Ticker, [Choice], [Width], [Height], [Visible], [Top], [Left], [Scale], [Text], [Return] )

Parameters

    
Ticker = Ticker symbol (e.g "MMM")

Choice = Type of date to insert into created comment. Defaults to a value of 1. Possible values:

     0 = Insert text only
     1 = Insert image of daily chart from Stockcharts' Gallery View for passed "Ticker"
     2 = Insert image of P&F Chart from StockCharts for passed "Ticker"
     3 = Insert image of 6-month Candleglance Chart from StockCharts for passed "Ticker"
     4 = Insert image of 6-month chart from Business Week Online for passed "Ticker"
    99 = Insert custom image using the "Ticker" field value as the URL of the image. Excel appears to have a limit of 100 bytes for this URL.

Width = Width (in pixels) of comment box. Optional except when Choice=99. Default values vary depending on the value of "Choice".

Height = Height (in pixels) of comment box. Optional except when Choice=99. Default values vary depending on the value of "Choice".

Visible = A binary value to indicate whether the comment should be visible or hidden; optional; defaults to 0 (hidden).

    0 = Keep comment hidden
    1 = Make comment visible

Top = Top position (in pixels) of comment relative to the top of the cell containing the formula. Defaults to 1.

Left = Leftmost position (in pixels) of comment relative to the left of the cell containing the formula. Defaults to 1.

Scale = Scaling amount to apply to Choice-based height and width sizes. Defaults to 100%.

Text = Text data to place into comment box. In most cases, you would NOT use this if you are loading an image. Defaults to "".

Return = Data to return as the value for the cell. Defaults to "Chart".


Examples Usage notes