|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- On Error Resume Next
- Sheet3.Unprotect Password:="695360052"
- If Target.Value <> "" Then
- Target.Locked = True
- Sheet3.Protect Password:="695360052"
- End If
- If Target.Column = 3 And Target.Row > 1 Then
- Unload 本行数据快速录入窗口
- 本行数据快速录入窗口.Show 0
- Dim arr
- arr = Target.Offset(, -2).Resize(, 50).Value
-
- 'arr = Split(Target.Value, "")
- For i = LBound(arr, 2) To UBound(arr, 2)
- 本行数据快速录入窗口.Controls("textbox" & i).Text = arr(1, i)
- Next
- ' 单据录单窗口.Controls("label51").Caption = "记帐日期:" & ActiveCell.Offset(, -2)
- ' 单据录单窗口.Controls("label52").Caption = "贷方金额:" & ActiveCell.Offset(, 2)
- ' 单据录单窗口.Controls("label53").Caption = "对方帐户:" & ActiveCell.Offset(, 4)
- ' 单据录单窗口.Controls("label54").Caption = "摘要A:" & ActiveCell.Offset(, 6)
- ' 单据录单窗口.Controls("label55").Caption = "摘要B:" & ActiveCell.Offset(, 7)
- End If
- End Sub
复制代码 加载后要这样的效果么? |
|