About call the inputbox when cell is selected i already fixed it by using the following code in the sheet code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$I$12" Then
Application.Run ("PASS")
End If
End Sub
Now the problem is all about the inputbox.
I would like it to show a message "Code accepted" if it was equal to any of the ones in the list i have in a range of cells. And if was not show another message like "This code does not exist. Please try again."
Someone can help please?
Bookmarks