|
Private Sub Worksheet_Change(ByVal Target As Range)
If Application.Intersect(Range("d8:d17"), Target) Is Nothing Or Target.Count > 1 Then Exit Sub
If D.Count = 0 Then Call 代码存为数组
If Target.Value = "" Then
Target.Offset(0, 1) = ""
Target.Offset(0, 2) = ""
Target.Offset(0, 3) = ""
Else
Target.Offset(0, 1) = Split(D(CStr(Target.Value)), "-" )(0)
Target.Offset(0, 2) = Split(D(CStr(Target.Value)), "-" )(1)
End If
End Sub就是当我输入产品编号后,就会代出后面的几项
如果我的的代码表有5列,我这个入库表要返回4个值这段代码怎么改,
如图
|
|