Direct Drop in TextBox

[IoanZ]

Hello to everyone.


Please help me


I have this userform


https://imgur.com/bdp5zwE


I this userform I have a listbox with Names and a TextBox


In present each time when i select a name from ListBox i must select with mouse the TextBox to enter value there


I want to know which is vba code to be directly throw in TextBox, after I have selected a name from listbox?




Thank's a lot

 

[jkpieterse]

Textbox1.SetFocus sets the focus to TextBox1. Add that to the click event of the listbox.

 

[My Aswer Is This]

Try this:

Private Sub ListBox1_Click()
'Modified  4/3/2019  2:59:58 AM  EDT
TextBox1.Value = ListBox1.Value
End Sub

 

[IoanZ]

Thank's for your answers
Work's perfectly

 

[My Aswer Is This]

Not sure which answer you used.
But:
Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank's for your answers
Work's perfectly