Hey guys,
I finally got it working the last part of the code finishes with:
EplySel.ComboBo x1.AddItem Data
Loop
EplySel.Show
Close #1
End Sub
Thanks you all.
letobale1982
Last Activity: Nov 7 '08, 03:15 AM
Joined: Jan 22 '08
Location: Mexico
-
Yes, I am using the variable Data to store the content of a .txt file that is read first. Code below.
Public Data As String
Public i As Integer
Sub ImportRange()
Dim ImpRng As Range
Dim FileName As String
Dim r As Long
Dim c As Integer
Dim Char As String * 1
Set ImpRng = ActiveCell
On Error Resume Next
FileName = "C:\textfile.tx t"
...Leave a comment:
-
How to add the content of a variable to a ComboBox
Hello everybody,
I would like to know how do I add the content of a variable to a combobox.
I have the following code
For i = 1 to 10
ComboBox1.AddIt em Data, i
Next i
Where I declared previously:
Public Data As String
Public i As Integer
When I run my code mi combo box just shows empty.
Hope someone can help me out. -
How to modify Combobox during runtime
Hello I would like to get some ideas on how to modify a Combobox during runtime and save the changes so next time the form is ran changes are available.
Here is the plan.
A form displays a combobox that get populated with several items.
Next to the combobox I will add three buttons: Add, Delete and Modify.
My idea is that the combobox will read a previously created file with the items of the list.
...
No activity results to display
Leave a comment: