editing a cell( via doubleclicking) vs Copying /cut and pasting or scrolling through cells in a specific Column
Posted on 2013-11-15
Excel 2010 vba..
I have a variable that holds a specific Column Number for other purposes.
trColumn as String
I need to know:
Is there a way, that if i "Double Click in a cell anywhere in that specific Column.
I can fire off an event...?
If a person copys/cuts and pastes or scrolls on cells in that Column...or anything else...
I do not want the event fired off?
The event i want to capture this in is:
Private Sub xlApp_SheetChange(ByVal Sh As Object, ByVal Target As Range)
or maybe here ?
Private Sub xlApp_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
I think something like this would work.
If i know trColumn = "H"
Select Case ActiveCell.Address
Case "$trColumn" ?
'do something for column trColumn