|
楼主 |
发表于 2014-3-24 14:20
|
显示全部楼层
hwc2ycy 发表于 2014-3-24 14:07
跟着活动单元格跑好不?
如果是活动单元格的,我已经有类似代码了,就是不知道怎么连接到表单型的组合框中和实现产品列表增加就自动增加到组合框中,麻烦帮忙看看是否有办法?非常感谢!
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> [f4].Address Then Exit Sub
If Target.Count > 1 Then Exit Sub
Dim rng As Range, rw&
rw = [b65536].End(3).Row
Set rng = Sheets("产品列表").[a1].CurrentRegion.Find(Target, lookat:=xlWhole)
[c11] = rng.Offset(b2, 1)
[d11] = rng.Offset(b3, 2)
[e11] = rng.Offset(b4, 3)
[c11:e11].AutoFill Destination:=Range("c11:e" & rw), Type:=xlFillDefault
End Sub
|
|