با اضافه کردن دستور ELSEIF کدها را ادامه دهید
کد PHP:
Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("A1")) Is Nothing Then
Range("B1").NumberFormat = "[h]:mm;@"
Range("B1") = Range("B1") + Target
ElseIf Not Intersect(Target, Me.Range("A2")) Is Nothing Then
Range("B2").NumberFormat = "[h]:mm;@"
Range("B2") = Range("B2") + Target
ElseIf Not Intersect(Target, Me.Range("A3")) Is Nothing Then
Range("B3").NumberFormat = "[h]:mm;@"
Range("B3") = Range("B3") + Target
End If
End Sub
علاقه مندی ها (Bookmarks)