Function argument selection style in Excel

Add-in Express™ Support Service
That's what is more important than anything else

Function argument selection style in Excel
How to get animated dotted cell border 
nitin c




Posts: 79
 Joined: 2007-05-18
Hi,

In Excel 2003,
1. Click on "fx" button
2. Select a function
3. give cell reference by clicking on worksheet (observe the cell selected)

I want to achieve this same effect in my addin. Any ideas how I can get it? Basically I am trying to build a formula editor for my UDF.

Thanks,
Nitin
Posted 05 Jun, 2007 02:11:22 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Nitin.

You need to add a new ADXExcelAddinModule class to the project. Then you can develop your own public functions available in Excel.



P.S. Note that we take up your forum requests in the order we receive them.
Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
Posted 06 Jun, 2007 09:26:59 Top
nitin c




Posts: 79
 Joined: 2007-05-18
Sergey, I have already used ADXExcelAddinModule and developed a UDF, now I am trying to provide a custom formula editor for my users.

So now when users use my formula editor, they should be able to click on a cell which will be used as the argument value. I want this feature to resemble to the excel "fx" cell reference selection feature.

Thanks,
Nitin
Posted 07 Jun, 2007 05:19:19 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Nitin,
in this case you can develope a COM add-in that will contain a form with you own editor.

Posted 07 Jun, 2007 08:31:04 Top
nitin c




Posts: 79
 Joined: 2007-05-18
Hi Sergey,

Actually I have built COM add-in with a form which is my formula editor, and my formula editor also supports using cell references, however the way cell's are selected in my case is different from the way "fx" selects.

In my case - cell selection is nothing by clicking on any cell(heavy border around the cell
In "fx" case - cell selection causes the cell to have thin dotted animated line.

I want help getting the animation effect.

Thanks,
Nitin.
Posted 08 Jun, 2007 01:09:19 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Nitin.

I am not sure that it is possible. Please try to find something helpful here:
http://www.codeproject.com/script/articles/subcat.asp?id=17
Posted 08 Jun, 2007 08:04:06 Top