返回列表 上一主題 發帖

請教如何修改程式

Private Sub ComboBox1_DropButtonClick()
Dim DataBook As Workbook
On Error Resume Next
Set DataBook = Workbooks("資料庫.xlsm")
On Error GoTo 0
If DataBook Is Nothing Then MsgBox "資料庫檔案未開啟! ": Exit Sub

With DataBook.Sheets("工作表1")
   ar = .Range(.[A4], .[A3].End(xlDown).Offset(, 5))
   With ComboBox1
      .ColumnCount = 3
      .List = ar
      .ColumnWidths = "0,30,40"
   End With
End With
End Sub

TOP

        靜思自在 : 能幹不幹,不如苦幹實幹。
返回列表 上一主題