Option ExplicitPrivate Sub Command1_Click() Combo1.AddItem "数据1" Combo1.AddItem "数据2" Combo1.AddItem "数据3" Combo1.AddItem "数据4" Combo1.AddItem "数据5" Combo1.AddItem "数据6" End SubPrivate Sub Command2_Click() Dim FileNumber As Integer Dim i As Long On Error Resume Next
If Dir("c:\ComBoxData.txt") <> "" Then Kill "c:\ComBoxData.txt" FileNumber = FreeFile Open "c:\ComBoxData.txt" For Output As #FileNumber For i = 0 To Combo1.ListCount - 1 Debug.Print Combo1.List(i) Print #FileNumber, Combo1.List(i) '& vbCrLf Next Close #FileNumber End SubPrivate Sub Form_Load() Dim FileNumber As Integer Dim i As Long Dim MyValue As String On Error Resume Next
FileNumber = FreeFile Open "c:\ComBoxData.txt" For Input As #FileNumber Do While Not EOF(FileNumber) Line Input #FileNumber, MyValue Combo1.AddItem Trim(MyValue) Loop Close #FileNumber End Sub
Combo1.AddItem "数据1"
Combo1.AddItem "数据2"
Combo1.AddItem "数据3"
Combo1.AddItem "数据4"
Combo1.AddItem "数据5"
Combo1.AddItem "数据6"
End SubPrivate Sub Command2_Click()
Dim FileNumber As Integer
Dim i As Long
On Error Resume Next
If Dir("c:\ComBoxData.txt") <> "" Then Kill "c:\ComBoxData.txt"
FileNumber = FreeFile
Open "c:\ComBoxData.txt" For Output As #FileNumber
For i = 0 To Combo1.ListCount - 1
Debug.Print Combo1.List(i)
Print #FileNumber, Combo1.List(i) '& vbCrLf
Next
Close #FileNumber
End SubPrivate Sub Form_Load()
Dim FileNumber As Integer
Dim i As Long
Dim MyValue As String
On Error Resume Next
Command1.Caption = "输入组合框数据"
Command2.Caption = "保存组合框数据"
Combo1.Text = ""
If Dir("c:\ComBoxData.txt") = "" Then Exit Sub
FileNumber = FreeFile
Open "c:\ComBoxData.txt" For Input As #FileNumber
Do While Not EOF(FileNumber)
Line Input #FileNumber, MyValue
Combo1.AddItem Trim(MyValue)
Loop
Close #FileNumber
End Sub
5楼 Form_Load 就是将已经存在的文件c:\ComBoxData.txt写入组合框项目中。