command button sub
Hi why wont this work for a command button, what should I write instead?
Private Sub CommandButton3_Click()
If Not Intersect(Target, Range("patientlist")) Is Nothing Then
UserForm2.TextBox1.Value = ActiveCell.Value
UserForm2.Show
End If
End Sub
|