|
楼主 |
发表于 2013-12-5 13:33
|
显示全部楼层
本帖最后由 ericzhu2013 于 2013-12-5 13:37 编辑
hwc2ycy 发表于 2013-12-5 12:51
表格不规范。
Private Sub ComboMonth_Enter()
Dim i As Long
Sheet1.ComboMonth.Clear
With Sheet1.ComboMonth
For i = 2 To 65535
If Sheet1.Cells(i, 1) = ("Jan" Or "Feb" Or "Mar" Or "Apr" Or "May" Or "Jun" Or "Jul" Or "Aug" Or "Sep" Or "Oct" Or "Nov" Or "Dec") Then
.AddItem Sheet1.Cells(i, 1)
Else
Exit For
End If
Next
End With
End Sub
Private Sub ComboInfo_Enter()
Dim Info As String
Dim i As Long
For i = 2 To 65535
If Sheet1.Cells(i, 2) = "" Then
Exit For
Else
If Sheet1.Cells(i, 1) = ComboBox1.Text Then
ComboBox2.AddItem Sheet1.Cells(i, 2)
End If
End If
End Sub
我把code贴出来了,版主帮忙看看吧 |
|