hi there,
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.
Code
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
Display More