Hi,
In my userform, I have a search button that gives me search results in a listbox1.
After I have the results, is there a way to double-click on one item and to open listbox2 where I can read the full continent of the item (CELL) and to close the listbox2 &return to my previous results.
I joined a test userform that can help to understand.
Last edited by Ray316; 07-21-2011 at 03:31 PM.
Hello Ray316,
I added a third column to ListBox1 that holds the sheet name and address. This string gets passed to UserForm2 which display the full text in a TextBox. The attached file has all the changes made to it.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Ross,
I tried it, and it works, as long I do search before. But if there is no results, and the user doubleclick the listbox1 there is error message by VBA.
How can I solve that?
hello Ray316,
Copy and replace the event code for ListBox1 with the code below.
Please Login or Register to view this content.
Hi Lieth Ross,
Thank you very much for your help.
It works perfectly.
A++++++
Hello Ray316,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks