Excel modeless form issue

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

Excel modeless form issue
 
OliverM


Guest


In my ADX add-in I am trying to implement a mode less form providing log information.
The form includes a search bar allowing to search for a given string in the displayed log messages.
It turns out, as soon as I start typing in the search box the focus changes back to the active Excel sheet, and all typed keyboard characters are inserted into a cell instead of the search bar.

I can reproduce the issue with a standard System.Windows.Forms with just a single System.Windows.Forms.TextBox added.

The issue does not occur when using a VBA mode less form together with a textbox.

Do you guys have any idea how to workaround the issue?
Posted 20 Dec, 2017 08:25:32 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Oliver,

You should use an Add-in Express pane instead.


Andrei Smolin
Add-in Express Team Leader
Posted 20 Dec, 2017 09:22:21 Top
OliverM


Guest


Hi Andrei,

Thank you for your recommendation. I moved the search bar to an ADXExcelTaskPane which is automatically shown/hidden depending on whether an event log instance has been created/destroyed.

This significantly improves usability as the user does no longer have to switch from the Excel main window to the event log window in order to check if a given string can be found in the log.
Posted 21 Dec, 2017 08:12:46 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
You are welcome!


Andrei Smolin
Add-in Express Team Leader
Posted 22 Dec, 2017 01:24:21 Top