I have a drop-down with the following items:
New
Uniform
Uni. Instr.
Instructor
Assist.
Old
The following partial code works for all selections except "Uni. Instr." ie If line 10 is If CelChosen = "Uni. Instr." then. Please tell me where I'm going wrong, (relative newbie to macros)
1 LastRow = Worksheets("All").Cells(Worksheets("All").Rows.Count, "C").End(xlUp).Row
2 If Not Intersect(Target, Range("A3:A" & LastRow)) Is Nothing And ActiveCell.Row > 2 Then
3 On Error GoTo Getout
4 If Target.Offset(, 2).Value <> "" Then
5 CelChosen = Target(1, 1).Value
6 MNo = Target.Offset(, 1).Value
7 End If
8 End If
9
10 If CelChosen = "Uniform" then
11 MsgBox CelChosen
12 End If
Bookmarks