Originally Posted by
lehgzil
hi jarry,
is it like this?, when you choose a value from combobox1, it will produce an update value on a textbox which are both on the userform?
try this
**from youre previous thread**
[vba]Private Sub UserForm_Initialize()
UserForm1.Controls("combobox1").List = Array("first item", "second item")
UserForm1.Controls("combobox1").DropDown
End Sub
'add this outside the userform initialize event. on the combobox_change event
Private Sub ComboBox1_Change()
textbox1.value = vbnullstring
Select Case ComboBox1.Value
Case "first item"
textbox1.value = "first item choice"
Case "second item"
textbox1.value = "second item choice"
end select
end sub[/vba]
hope this works