Excel ListObject Events

Sep 17, 2012 at 1:19 PM

Hi Sebastian,

I have a listobject in Excel,created via NetOffice (Forms.ListBox.1), I can see the Got/Lost Focus events, but not change/keydown etc. Does NetOffice support these events?

Dave

Coordinator
Sep 18, 2012 at 8:09 AM

hey dave,

NetOffice doesnt miss any event/property/method.
did you have a code snippet for me? *as much you can*

Sebastian

Sep 18, 2012 at 9:43 AM

Hey,

When I examine the MS Forms.ListBox.1 control in Excel VBE (2007) I see a number of events I wish to capture, but don't see them on ListBox class in NetOffice.

 

NetOffice.ExcelApi.OLEObjects objects = (NetOffice.ExcelApi.OLEObjects)WorkSheet.OLEObjects();

Excel.OLEObject listObject = null;

listObject = objects.Add("Forms.ListBox.1");

Excel.ListBox list = (Excel.ListBox)listObject.Object;

 

I can only see the got and lost focus events on the Excel.ListBox Control, I want to hook the keyboard press/up events.

Dave

Coordinator
Sep 18, 2012 at 4:19 PM

as far i known today this is impossible becauce its impossible in the interop assemblies. VSTO contains a special service here:

http://msdn.microsoft.com/de-de/library/microsoft.office.tools.excel.controls.listbox.aspx

but you need the vsto runtime and its not true version independent of course :(

Sebastian