|
abcttud 发表于 2013-4-24 12:34
老师冻结是能实现,谢谢!因为我工作电脑能实现这一功能,不过没有代码?
换一种思路,用ACTIVE按钮就可以了。(自己可以再加调整)
Sub test()
Dim Arr, D, i&
Set D = CreateObject("scripting.dictionary")
Arr = Range("a1:d" & Cells(Rows.Count, 1).End(xlUp).Row)
For i = 1 To UBound(Arr)
D(Arr(i, 2)) = Arr(i, 1)
Next
For i = 1 To UBound(Arr)
If D.exists(Right(Cells(i, 3), 6) * 1) Then Arr(i, 4) = D(Right(Cells(i, 3), 6) * 1)
Next
[a1].Resize(UBound(Arr), 4) = Arr
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
CommandButton1.Top = Target(Target.Count).Top - Target(1).RowHeight * 10
CommandButton1.Left = Target(1).Left + Target(1).ColumnWidth * 10
End Sub
|
|