Difference between revisions of "XL3Link"
(→Parameters) |
(→Parameters) |
||
| Line 26: | Line 26: | ||
|- | |- | ||
| 3 || HyperLink with submit changes on web | | 3 || HyperLink with submit changes on web | ||
| + | |- | ||
| + | | 4 || Toolbar button on web | ||
|} | |} | ||
|- | |- | ||
Revision as of 16:33, 6 August 2014
Creates a hyperlink that opens a sheet and sets parameters. When you follow the hyperlink, XLCubed jumps to the sheet stored at LinkLocation and sets the parameters at the specified parameter addresses.
Use the Insert Formula > XL3Link menu or ribbon item to insert the formula using a wizard. More details can be found here.
Contents
[hide]Syntax
XL3Link( [LinkLocation], [FriendlyName], [LinkType], [Range1], [Value1],…, [Range13], [Value13] )
Parameters
| Parameter | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| LinkLocation | A piece of text, indicating the location to jump to. Can be a text string enclosed in quotation marks or, more commonly, an XL3Address formula | ||||||||
| FriendlyName | The jump text or numeric value that is displayed in the cell. If FriendlyName is omitted, the cell displays the LinkLocation as the jump text | ||||||||
| LinkType | The type of link. If Hyperlink is used, the cell is formatted with the Excel style Hyperlink
| ||||||||
| Range1,…, RangeN | A reference to a cell where the following Value is placed when the jump is executed. Usually an XL3Address formula | ||||||||
| Value,…, ValueN | The value that will passed to the corresponding Range |
Examples
The following XL3Link formula creates an hyperlink to the 'LinkTarget' sheet and shows in the hyperlink the text "Jump to Target Sheet"
=XL3Link( XL3Address( LinkTarget!A1 ), "Jump to Target Sheet" )
You can use XL3Link to jump from one sheet to another sheet in the workbook, while passing some parameters. The following formula jumps to the sheet 'LinkTarget' and sets value 'Car and Bike Stores' at LinkTarget!A2.
=XL3Link( XL3Address( LinkTarget!A1 ), "Jump to Target Sheet and pass 'Car and Bike Stores'", 1, XL3Address( LinkTarget!A2 ), "Car and Bike Stores" )
