Showing argument descriptions as an XLL worksheet function is type
in [Programming]
|
Prev: How to skip the confirmation on updating link?
Next: DoneEx XCell Compiler - comments on VBA protection?
From: John McDowell on 26 Mar 2010 22:05 Hi, Apologies if this is wrong newsgroup, I wasn't sure if this or microsoft.public.excel.sdk is better. We're developing a set of XLL worksheet functions that have 5-8 difficult to remember arguments. While the argument descriptions passed to the registration function display properly in the function wizard, they do not appear in the common case of typing the function in the formula bar. In addition, I have these related (but lesser) concerns: - My worksheet function description does not appear when my function name is being typed in the Formula Bar. - My add-in description text is not displayed in the Add-in Wizard. Unfortunately, the sample "GENERIC" provided in the SDK seems to have the same issues. I do not believe these are general limitations of the XLL SDK, as the Analysis Toolpak XLL and its functions do not have these issues. For example, add the Toolpak Add-In, observe the description and type "MROUND" in the formula bar. Can someone take a look at how to get argument descriptions to work in the formula bar? I haven't been able to locate this knowledge in Steve Dalton's book or on the existing internet resources. Thanks very much, John McDowell
From: Niek Otten on 27 Mar 2010 04:58
Look here: http://www.jkp-ads.com/Articles/RegisterUDF00.asp -- Kind regards, Niek Otten Microsoft MVP - Excel "John McDowell" <JohnMcDowell(a)discussions.microsoft.com> wrote in message news:136B7864-C8B9-47A0-9B4B-C462F0B14F94(a)microsoft.com... > Hi, > > Apologies if this is wrong newsgroup, I wasn't sure if this or > microsoft.public.excel.sdk is better. > > We're developing a set of XLL worksheet functions that have 5-8 difficult > to > remember arguments. > > While the argument descriptions passed to the registration function > display > properly in the function wizard, they do not appear in the common case of > typing the function in the formula bar. > > In addition, I have these related (but lesser) concerns: > - My worksheet function description does not appear when my function > name is being typed in the Formula Bar. > - My add-in description text is not displayed in the Add-in Wizard. > > Unfortunately, the sample "GENERIC" provided in the SDK seems to have the > same issues. > > I do not believe these are general limitations of the XLL SDK, as the > Analysis Toolpak XLL and its functions do not have these issues. For > example, add the Toolpak Add-In, observe the description and type "MROUND" > in > the formula bar. > > Can someone take a look at how to get argument descriptions to work in the > formula bar? I haven't been able to locate this knowledge in Steve > Dalton's > book or on the existing internet resources. > > Thanks very much, > John McDowell > |