Hi!
I have a listbox with a couple of items in a vba userform. I want to store the selected items in an array or something when i hit a button. Is this something you could help me with? I would very much appreciate it. Thank you
Hi!
I have a listbox with a couple of items in a vba userform. I want to store the selected items in an array or something when i hit a button. Is this something you could help me with? I would very much appreciate it. Thank you
Perhaps something like this
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.
Thanks for your quick reply. I have highlighted problems i have with the code.
I was also wondering how to use debug.print to check it out in the immediate window. Thanks so much for your help so far.Please Login or Register to view this content.
Sorry that should be
and .ListCount.Please Login or Register to view this content.
as for debugging, puttingwould be one way.Please Login or Register to view this content.
Hi,
I have a similar question to this but with a slight twist:
Im working with a multiselect listbox and I want to store the index of the selected items into an array instead of the value of the selected items.
I have tried using the Listindex, but I cant make it read all of the selected items index. It only reads the index of the first selected item.
Hopefully someone can help me!
Welcome to the forum Pamela2411
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry! Will do so
No problem. Sure you'll get a great response.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks