Excel Automation SelectionChange event

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable SelectionChange Event 2
How To Assigned "SelectionChange" Event To different Worksheets 3
Worksheet SelectionChange Event 2
Alt codes 4
SelectionChange event 2
Run-Time error '13': Type mismatch 1
Worksheet Activate event not firing 4
SelectionChange and Pivot Tables 2

Top