I have a 2 column, 20 row multiselect Listbox in a user form with source data from range ("C19:D38"). I have a command button to "Select All", "Select None" and "Save Selcted".
I want the "Save Selected" Command Button" to return a 1 or 0 into cells E19:E38, depending on which values in the Listbox are selected.
This is being done in the Sheet called ("CashFlow")
All my VBA skill are learnt from here so not high proficient.. Any help out there.. much appreciated.
You didn't give the name of the button or the name of the list box. So you will have to make adjustments. Add this code to the code for the UserForm:
Please Login or Register to view this content.
6StringJazzer: That was very clean and effective.. I'll change the Command Button and Listbox names to fit my model... What would I need to change to make this dynamic, and hence not having to use a command button to save the selected items.
I'm not sure what you want from the user's point of view. Do you want to change the cell contents every time the user clicks on an item, to either select or deselect it? You can't detect which individual row was clicked, so you have to check all rows every time there is any change in selection. But this is very fast so you won't notice. You would simply replace
withPlease Login or Register to view this content.
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