james.rees02
New Member
- Joined
- Mar 26, 2009
- Messages
- 5
Hi,<o></o>
<o> </o>
I am creating an add-in in Excel that will be used by various people within a department. <o></o>
<o> </o>
One of the functionalities I would like to add is a “drill-down” feature that upon double-clicking a number in a cell, Excel would query an Access database and return the detail that makes up the number. <o></o>
<o> </o>
My question is how to go about this? The Excel/Access interaction is not a problem, but how do I go about getting the double-clicking to work. <o></o>
I’ve tried adding the “Workbook_SheetBeforeDoubleClick” sub in the add-in, but that only works if the add-in is active. I need this to work on whatever workbook is currently active (since the add-in is hidden anyway)<o></o>
<o> </o>
Any suggestions would be greatly appreciated?<o></o>
Thank!<o></o>
<o> </o>
I am creating an add-in in Excel that will be used by various people within a department. <o></o>
<o> </o>
One of the functionalities I would like to add is a “drill-down” feature that upon double-clicking a number in a cell, Excel would query an Access database and return the detail that makes up the number. <o></o>
<o> </o>
My question is how to go about this? The Excel/Access interaction is not a problem, but how do I go about getting the double-clicking to work. <o></o>
I’ve tried adding the “Workbook_SheetBeforeDoubleClick” sub in the add-in, but that only works if the add-in is active. I need this to work on whatever workbook is currently active (since the add-in is hidden anyway)<o></o>
<o> </o>
Any suggestions would be greatly appreciated?<o></o>
Thank!<o></o>