Hi Guys
On my Userform I have 10 listboxes populated from the excel sheet. I have another listbox(listbox11) where I would like to selected a random item from listbox1 add to listbox11 and delete the item from listbox1 to listbox10.
The code at the current moment works partially. It directly skips to listbox10 Please can you help so the code works completely.
Please Login or Register to view this content.
Last edited by aleemj; 08-04-2012 at 08:20 AM. Reason: breaching code 3
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here's a little code you might be able to play around with and get to work. If you cant and still want help upload your workbook.
Please Login or Register to view this content.
Hi Richard
I have attached my excel file. I tried using your code with no success.
Thankyou for help
How does the user indicate which item is to be removed from Listboxes 1-10 and added to ListBox11?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Listbox1 is populated by the excel sheet, column A. There is button within the user which generates the random item deletes it from listbox1, and add listbox 11. I want the item which has been add to the listbox 11 remove all other listboxes but they may places at difference indices
Please Login or Register to view this content.
Last edited by arlu1201; 08-04-2012 at 01:11 PM.
aleemj,
Welcome to the forum.
I have added code tags to your post in place of the quote tags that you had put. As per forum rule 3, you need to use them whenever you put any code in your post, as told to you earlier in this thread. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@aleemj
Ok looking over your form now. What Exactly are you wanting to due? From your original post and looking at your Form I cannot tell what your wanting.On my Userform I have 10 listboxes populated from the excel sheet. I have another listbox(listbox11) where I would like to selected a random item from listbox1 add to listbox11 and delete the item from listbox1 to listbox10.
Something like
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks