Button does not add in sequence from top to bottom. On a VBA, and drop down issues.

[joramos10]

Have two issues when selecting the drop down will like to populate the column "A2" and so on as I click the add button.

Also is the issue for the information does not go in order, Seems to go always to the top row. Goal is to populate the rows in sequence with the information given.

Any help will be appreciated

[jindon]

Not really sure, but do you want?

Please Login or Register  to view this content.

If this is correct, you also need to check if ComboBox1 is not blank when ADD button has been clicked.

[joramos10]

Do you think this will work?


If ComboBox1.ListCount = 0 Then
MsgBox "List Empty"
End If

With ComboBox1
.AddItem "324"
.AddItem "373"
.AddItem "412"
End With

If ComboBox1.ListCount > 0 Then
MsgBox "Combobox1 has " & ComboBox1.ListCount & " entries"
End If

End Sub