Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
script detecting the change of active cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
script detecting the change of active cell
I don't know how you could trap an Excel event without using Excel events.
Am I missing something here? -- Vasant "Jack" <replyto@newsgroup wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Cell To Change Formula | Excel Discussion (Misc queries) | |||
Cell value - detecting change | Excel Worksheet Functions | |||
Change Formatting In 'Active' Cell | Excel Discussion (Misc queries) | |||
Detecting active customview | Excel Discussion (Misc queries) |