klnp_mysore
Board Regular
- Joined
- Mar 2, 2011
- Messages
- 64
Hi,
I want to add the selected value from listbox to textbox. Please Help me
Regards
I want to add the selected value from listbox to textbox. Please Help me
Regards
This could be one way:
Private Sub ListBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox1.Value = Me.ListBox1.Value
End Sub
Although you didn't mention if your controls are on a worksheet or user form.
HTH,
Also...
Private Sub CommandButton1_Click()
Me.TextBox1.Value = Me.ListBox1.List(Me.ListBox1.ListIndex)
End Sub