Keyboard's commands fail in Excel VB Editor

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

Keyboard's commands fail in Excel VB Editor
Created keyboard's commands fail in Excel VB Editor 
Dennis Wallentin




Posts: 29
Joined: 2007-08-28
Hello all,

Background, I create Excel Add-ins that explicit target the VB Editor in MS Excel 2010-2016.
My setup is the following:
VS 2015 Patched
MS Excel 2016 x64
Add-in Express Premium version 8.3.4393
Windows 10 x64 with elevated rights.

For me it's easy to reproduce the issue:
1. Create an Add-in
2. Add an ADXKeyboardShortcut
3. Add the ShortcutText: Ctrl+Shift+B
3.1 Add the procedure with a simple (in VB.NET) Messagebox.Show("B")
4. Save and run the project

When running the project
1. In Excel view enter Ctrl+Shift+B and it will works (although it's not in this view the code is intended for).
2. In VB Editor view it does not work and instead through a "System.OverflowException in AddinExpress.MSO.2005.dll" error message. It doesn't crash the Add-in or Excel.

It was a time since last time I worked with an Add-in that explicit target the VB Editor.

Has there been any modification that prevent us from running short commands in the VB Editor? When I worked professionally for some years ago I never faced this limit or bug. At least, that's what I remember.

Please let me know how to resolve it.

TIA,
Dennis
Kind regards,
Dennis
Posted 10 Nov, 2016 10:21:31 Top
Andrei Smolin


Add-in Express team


Posts: 14108
Joined: 2006-05-11
Hello Dennis,

We've reproduced the issue. It is now filed under #9726 in our bug-tracking DB.

Our guys look into this. When I know a time estimation, I'll let you know.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 11 Nov, 2016 05:31:42 Top
Dennis Wallentin




Posts: 29
Joined: 2007-08-28
Andrei,

Thank You!

All the best,
Dennnis
Kind regards,
Dennis
Posted 11 Nov, 2016 06:02:41 Top
Andrei Smolin


Add-in Express team


Posts: 14108
Joined: 2006-05-11
To All,

We've published a new build and Dennis informed me that it fixed the issue in a private email.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 18 Nov, 2016 09:23:42 Top