<div>
Public Sub FillMy(ByRef cb As ComboBox, st As String) 
Dim I As Long 
Dim b As Long 
Dim c As String 
If (Len(RTrim(LTrim(st))) = 0) Then Exit Sub 
Do 
&nbsp;st = LTrim(RTrim(st)) 
&nbsp;b = InStr(1, st, &quot;&nbsp;&quot;) 
&nbsp;If (b &lt;&gt;&nbsp;0) Then 
&nbsp; &nbsp; c = Mid(st, 1, b - 1) 
&nbsp; &nbsp; st = Mid(st, b, Len(st) - b + 1) 
&nbsp; &nbsp;Else 
&nbsp; &nbsp; c = st 
&nbsp;End If 
&nbsp;cb.AddItem c 
Loop While b &lt;&gt;&nbsp;0 
End Sub
</div>

Public Sub FillMy(ByRef cb As ComboBox, st As String)
Dim I As Long
Dim b As Long
Dim c As String
If (Len(RTrim(LTrim(st))) = 0) Then Exit Sub
Do
 st = LTrim(RTrim(st))
 b = InStr(1, st, " ")
 If (b <> 0) Then
    c = Mid(st, 1, b - 1)
    st = Mid(st, b, Len(st) - b + 1)
   Else
    c = st
 End If
 cb.AddItem c
Loop While b <> 0
End Sub

<div>
<div class="content wysiwyg-content">
I have a sheet with a list of variables. &nbsp; How can i fill in this combo box with necessary inforatmion because the number of item &nbsp;can change with the time. 
For example: 
 
 
LOLO 
LILI 
LALA 
[Empty] 
[Empty] 
...... 
...... 
...... 
 
I like have just LOLO LILI LALA 

</div>
</div>

I have a sheet with a list of variables.   How can i fill in this combo box with necessary inforatmion because the number of item  can change with the time.
For example:


LOLO
LILI
LALA
[Empty]
[Empty]
......
......
......

I like have just LOLO LILI LALA


vba: How to fill in combobox in excell from sheet ?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.