Hi all,
I use the follow code to open Userform 2 when "x" is put in column 5 or 6.
The labels on this form are filled with data from the same worksheet (Data Gel).
If Target.Column = 5 Or Target.Column = 6 Then If Target.Value = "x" Then
With UserForm2
.lblGelCodeR.Caption =...