first off Happy Canada day weekend!.
I have a working combobox that shows selected items from a worksheet. i want to be able to show the selected text that i choose in the combobox in a textbox.
so say i select Apple in the combobox. the textbox underneath should display "Apple". how can i achieve this. here is the code for the combo box if it would help. anyhelp or hints would be greatly appreciated. thanks.
Private Sub cboLocation_Change() End Sub Private Sub UserForm_Initialize() Dim cLoc As Range Dim ws As Worksheet Set ws = Worksheets("sheet1") For Each cLoc In ws.Range("LocationList") ' With Me.cboLocation .AddItem cLoc.Value End With Next cLoc End Sub Private Sub toText_Change() ' is the textbox that needs to display the value i have selected from the combobox End Sub