Excel Add-in function

Chi Ly

Hi Everyone, 

 

I'm working on a report in excel using Board Add-in. 

 

Just wondering if there is any syntax or macro function that can get the current selection? 

 

I'm looking into the help section but couldn't find anything

 

Thanks,

Chi

Björn Reuber

Hi,

 

if you want to display the current selection, just add an @Selection to the layout header

 

regards

Björn

Previous Member

Hi Chi Ly,

 

check out Office add-in excel, keep format 

There is a what's called Substitution formulas named '@Selection'

With that you should see the value of the selection as text in a cell.

Make sure that the type of the algorithm is text

The result in Excel then could look like this:

 

BR, Ray