cpounds217
03-30-2018, 11:52 AM
Hi All!
This is for multiple applications I am creating, and I can't seem to find a code that works, and nor can I find any prior information on how to do this.
I am trying to take a Userform that initializes with a populated list from wsX.range(Varying length), and then if on the home worksheet in Range("A2:A") has values, using those values to pre-select the corresponding values in the listbox.
Example:
Listbox1 has the following items: A B C D E F G H I J K L M N O P
Range "A2:A".value = A F G H J K O P
So Listbox1 would return the list as populated above, but the range values would highlighted:
A B C D E F G H I J K L M N O P
The idea here is to allow the user to edit their selections without having to start over. I have searched and searched, but cannot find a solid way to do this.
Any help will be greatly appreciated, thanks!
This is for multiple applications I am creating, and I can't seem to find a code that works, and nor can I find any prior information on how to do this.
I am trying to take a Userform that initializes with a populated list from wsX.range(Varying length), and then if on the home worksheet in Range("A2:A") has values, using those values to pre-select the corresponding values in the listbox.
Example:
Listbox1 has the following items: A B C D E F G H I J K L M N O P
Range "A2:A".value = A F G H J K O P
So Listbox1 would return the list as populated above, but the range values would highlighted:
A B C D E F G H I J K L M N O P
The idea here is to allow the user to edit their selections without having to start over. I have searched and searched, but cannot find a solid way to do this.
Any help will be greatly appreciated, thanks!