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?


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*


Sep 18, 2012 at 9:43 AM


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.


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:


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