16,554
社区成员
发帖
与我相关
我的任务
分享
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 And Target.Row = 3 Then
If Target.Value = "例1" Then
Range("E3").Select
ActiveCell.FormulaR1C1 = "9:00"
Range("F3").Select
ActiveCell.FormulaR1C1 = "6:00"
Range("G3").Select
ActiveCell.FormulaR1C1 = "1小时"
Else
Range("E3").Select
ActiveCell.FormulaR1C1 = "手动填写"
Range("F3").Select
ActiveCell.FormulaR1C1 = "手动填写"
Range("G3").Select
ActiveCell.FormulaR1C1 = "手动填写"
End If
Range("D3").Select
End If
End Sub