excelcopytabbing

How to fill blank cell2 with value from cell1 on tabbing into it in Excel?


I need to fill a blank cell say D7 with value from A2 on tabbing into it with a NON vba solution.

Been trying to figure it out but having no luck.

Thanks


Solution

  • all Worksheet.ActivateEvent Events are handled by C# or VB. Such as

    Sub Worksheet1_ActivateEvent() Handles Me.ActivateEvent MsgBox(Me.Name & " was activated.") End Sub

    Unfortunately there is no way around it. Does your solution need to stay entirely in Excel?