script detecting the change of active cell

J

Jack

Hello,
I am not a user of Excel.
I do programming in vbasic and my code needs some kind of message from
Excel, that the active cell is changed.
Is it possible to have some Excel script detecting that and posting
something to clipboard, for example?
Your thoughts are appreciated.

Please note, that I cannot use Excel events so I cannot use the code as
shown below:

Public WithEvents moExcel As Excel.Application

Private Sub app_SheetSelectionChange(ByVal Sh As Object, ByVal Target As
Excel.Range)
Debug.Print "Selection Changed: " & Sh.Name & ":" & Target.Row & "," &
Target.Column
If Target.Rows.Count > 1 Or Target.Columns.Count > 1 Then
Debug.Print "multiple cells selected"
End If
End Sub
 
V

Vasant Nanavati

I don't know how you could trap an Excel event without using Excel events.
Am I missing something here?
 

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

Stop Active Cell from Firing Event after Hitting Return 1
Log changes in a range only 4
worksheet_change becoming active just by entering the cell 1
VBScript Event Sink Not Firing 6
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Change_Event not responding to change made by formula. 11
Need urgent help 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Top