search

Excel-DNA / IntelliSense

Add in-sheet IntelliSense for Excel UDFs
MIT License
169 stars 52 forks source link

IntelliSense v1.7.0-rc3 with VBA is a bit reluctant to do its stuff #129

Open PGS62 opened 1 year ago

PGS62 commented 1 year ago

If I create a super-simple addin containing only the two functions described in Getting Started plus the _IntelliSense_ worksheet (GitHub won't let me attach the addin to this post I'm afraid ☹️) then I see the following:

With IntelliSense v1.7.0-rc3 installed, if I make the addin open automatically, either by placing it in an "AltStart" folder, or else with File > Options > Addins, then IntelliSense does not work upon launching Excel. Closing and re-opening the addin brings IntelliSense to life however.

IntelliSense 1.4.2 is not "reluctant" in this way. It would be great to have a fix for this in the final version of 1.7 as I was hoping to upgrade to 1.7 to get the fix for #126 , but this issue would be a blocker.

govert commented 1 year ago

I'm trying to recreate this, but the problem is quite sensitive to the sequence of actions. I always seem to get the function descriptions showing next to the function list. So Excel-DNA IntelliSense is loaded and working. But then sometimes in the beginning of a session, the argument descriptions don't show. One way that seems to always show the argument descriptions is to double-click on the function name in the functions list, rather than pressing Tab to select it.

Am I seeing the same thing you're reporting, or is it worse for you where either the function descriptions are also missing, or you find the even double-click doesn't get the argument window showing?

There were some tweaks to the window tracking in recent updates, so I guess something went wrong.

govert commented 1 year ago

And after playing a bit, now I can't recreate the problem at all - everything shows every time . . .

govert commented 1 year ago

I'm using 64-bit Version 2302 (Build 16.0.16130.20332).