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
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?