ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Userform List box to Text Box (https://www.excelbanter.com/excel-discussion-misc-queries/110260-userform-list-box-text-box.html)

hazel

Userform List box to Text Box
 
Hi
I have a list box on a userform that is populated with names on selecting a
name from the list box how would I be able to show the selected name in a
text box on the same userform eg TextBox1. = Listbox1.name selected
--
Many thanks

hazel

Harald Staff

Userform List box to Text Box
 
Hi

Textbox1.Text = Listbox1.Text

in the Listbox1_click event

HTH. Best wishes Harald

"Hazel" skrev i melding
...
Hi
I have a list box on a userform that is populated with names on selecting
a
name from the list box how would I be able to show the selected name in a
text box on the same userform eg TextBox1. = Listbox1.name selected
--
Many thanks

hazel





All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com