Hello Gurus,
How can i display the Selected Item in listbox in textbox?
For Example: If I select, "1" in the Listbox, textbox1 will display "1", so on and so forth.
I've attached my file.
Thanks in advance Gurus!
Hello Gurus,
How can i display the Selected Item in listbox in textbox?
For Example: If I select, "1" in the Listbox, textbox1 will display "1", so on and so forth.
I've attached my file.
Thanks in advance Gurus!
Here's one way.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks Norie!
Hi Norie,
One thing, how can I amend the code to display in the listbox including the header for the below code?
Please Login or Register to view this content.
Sorry, I don't quite follow.
Do you want a header in the listbox?
If you do then you would need to use RowSource to populate it.
Yes Norie, i want to display also the Header in the Listbox. For the attached file, i want to display the 'Account Number' header and below is the account numbers. How can i do that?
You can't unless you use RowSource to populate the listbox from a contiguous range on a worksheet.
Why not just add a small label just above the listbox with the caption 'Account No'?
Last edited by Norie; 05-14-2014 at 08:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks