am using double click on each worksheet to open form
If Not Application.Intersect(Target, Range("b2:b" & lastRow)) Is Nothing Then ' OPEN FORM ON RECORD
Cancel = True
UserForm1.Show
Cancel = True
End If
I tried with code on the form to tell which sheet was clicked so i can know which row to get the data from to populate the form
I tried to check the text from a cell on the activesheet but that doesn't work
If ActiveSheet.Range("A1").value = "Date" Then getrowa = ActiveCell.Row
If ActiveSheet.Range("A1").value = "Event Date" Then getrowa = Worksheets("schedule").Cells(ActiveCell.Row, 10).value
what is the right way to do this?
Bookmarks