Vb updating combobox value
here goes: If i'm using simple Drop down style combo box(the one that looks like a listbox with textbox attached on top of the cbobx control) when i want to update one of the value in it, once i start typing in the textbox the selection inside the combo box is gone. Selected Index End Sub Private Sub Combo Box1_Lost Focus(By Val sender As Object, By Val e As System.
Thus i can't update the value inside the combo box.
At the moment I have to close and re-open the application.
However the combobox values do not update dynamically.
Sorted = True End Sub 'clears the list Private Sub Button4_Click(sender As Object, e As Event Args) Combo Box1. Clear() End Sub 'displaying the selected item on the label Private Sub Combo Box1_Selected Index Changed(sender As Object, e As Event Args) _ Handles List Box1.
My Combo_Change ' some code Dim str As String srt = general Settings Form. Value End Sub Could you clarify what you mean by "Row Source is a 2 columns range". When I use a single column range as the Row Source, everything works as you would like. Close() End Using End Using I then on the same form want to select the newly crated value from a combobox that links to this data source.The Combo Box control is used to display a drop-down list of various items. I cannot change the spreadsheet, and am trying to change the userform code as little as possible, because this is not my project. You need to change the value of the combobox - it doesn't work in both directions. So if you want to change it by passing a string, you need to look up what value that corresponds to, and set the value.