Hello
I have a listbox (listbox5), the source of the listbox is range "a5:a10". Is it possible that when i click on an item in the listbox, can I use a command click event from a button to display the item in a textbox along with the information in the same row up to column "C".
So to simplify, the row source is "a5:a10", if the item i selcetd in the listbox is at "a6", then i want the textbox to display "A6:C6" via click event from command button
Last edited by kmakjop; 06-25-2014 at 12:49 PM.
I would use a three column Listbox
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you for responding, i am getting an error message for the code you gave:
Please Login or Register to view this content.
However if i take out the last two me.textbox2 and me.textbox3, then it works, not sure why. I entered the code just as you told me and initialized the page as you have it there. But my list box doesnt come up with three columns, is that who it should be? i am wondering if thats where the problem is. the code below is what works, but what you suggested is not.
Please Login or Register to view this content.
Thank you for responding, i am getting an error message for the code you gave:
Please Login or Register to view this content.
However if i take out the last two me.textbox2 and me.textbox3, then it works, not sure why. I entered the code just as you told me and initialized the page as you have it there. But my list box doesnt come up with three columns, is that who it should be? i am wondering if thats where the problem is. the code below is what works, but what you suggested is not.
Please Login or Register to view this content.
Please ignore previous posts Issue solved thank you
The invisible columns of the ListBox were hidden by the .ColumnWidths statement.
I'm guessing that you're result involved something like
You also might want to look at the BoundColumn and TextColumn properties of a multi-column listbox, you might find them useful.Please Login or Register to view this content.
I did exactly what you suggested, use three different text boxes. The difference was i just changed the row source for each list box and let each list box populate its own text box. I know its the noob way but, i am learning VBA through my errors and what you guys in here teaches. Thanks again man.
About your "noob way". Its perfect.
Code that you can understand is the best code. Far better than efficient, concise, robust code that you don't understand.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks