Combobox - Problem on AddItem
I tried this:
Private Sub UserForm_Initialize()
Dim i As Integer
Dim ComboRange As Range
i = 5
While (ActiveSheet.Cells(1 + i, 11) < 0)
i = i + 1
If Cells(1 + i, 11).Text < "OK" And Cells(1 + i, 11).Text < "" Then
ComboRange = Range("A" & i & ":B" & i)
With ComboBox1
.ColumnWidths = "50;80"
.AddItem ComboRange
End With
End If
Wend
End Sub
But it doesn't work...
=(
|