I want to select any and only one fruit from an excel file, and once that selection is made, the fruit name along with its information gets assigned to a code next in line in a different excel file and those cells fill themselves with that information. Once that is done, the code # gets printed in the original excel file beside the fruit that was selected.
Images are below:
Capture1.PNG
Capture2.PNG
The VBA code to make the selection is already been written, so don't worry about that. FYI that code is:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("A2:A6")) Is Nothing Then
Application.EnableEvents = False
If ActiveCell.Value = ChrW(&H2713) Then
ActiveCell.ClearContents
Else
ActiveCell.Value = ChrW(&H2713)
End If
Cancel = True
End If
Application.EnableEvents = True
End Sub
Bookmarks