I have a user form that pops up when someone enters rejected in a cell in row AA. I need the form to unload into the corresponding cell in column AE. Unsure of how to get this done.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 27 And Target.Value = "Rejected" Then 'column 27 is column AA
REJECTED.Show 'replace UserForm1 with the name of your userform
If Not Intersect(Target, Range("AE:AE")) Is Nothing Then
With REJECTED
'TICKET ID
.REJECT.Value = Me.Cells(Target.Row, "AE").Value
End With
End If
End If
End Sub
Not sure of how to get this done.
Bookmarks