CODEWITHSUNDEEP
excelcopytabbing
xyz
xyz

Reputation: 2300

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

Upvotes: 0

Views: 58

Answers (1)

KLDavenport
KLDavenport

Reputation: 679

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?

Upvotes: 1

Related Questions