Excel Automation SelectionChange event
I am working on creating a spreadsheet through automation and I need to get
code into the selectionchange event of the spreadsheet to scan through another table to get some more values depending on multiple columns that have been entered in the spreadsheet. I have got the code figured out to make it work. I just can not figure out how to get the code into the selectionchange event of the spreadsheet using automation from vb. I have got macros added into the spreadsheet using Modules collection but I can't figure out how to get code into the selection change event. |
Hi
maybe the following helps you: http://www.cpearson.com/excel/vbe.htm -- Regards Frank Kabel Frankfurt, Germany "cpotts" schrieb im Newsbeitrag ... I am working on creating a spreadsheet through automation and I need to get code into the selectionchange event of the spreadsheet to scan through another table to get some more values depending on multiple columns that have been entered in the spreadsheet. I have got the code figured out to make it work. I just can not figure out how to get the code into the selectionchange event of the spreadsheet using automation from vb. I have got macros added into the spreadsheet using Modules collection but I can't figure out how to get code into the selection change event. |
All times are GMT +1. The time now is 07:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com