userform Multi select listbox - add contents to list

hi,

i have a multi select userform that loads details of a specific month selected, when the userform loads i want to be able to select the rows i need to update and when i press a command button (approved), the word "Yes" is added to the last column (named results). if i click the command button 'reject' i want the word 'no' to be added at the end of that line in results.

also, i only want the selected month to be shown in the list, at the moment it is showing both months

workbook attached.
thanks!

If you use RowSource to populate the listbox you won't be able to set Yes/No in the select column.

Also, you won't be able to filter by month.

Try this which use AddItem and List to populate the listbox.

Please Login or Register  to view this content.

By the way, how many of columns of data are there going to be?

You've set the column count of the listbox to 13 but there only appears to be 7 (or 8 if counting column A) of data.

If there is 13 columns then AddItem and List can't be used to populate the listbox, and another method will be needed - probably an array.

You never mentioned the Done button.

Where does the data need to go?

Is it the Result column?

I''ve updated the code to use an array to store the row numbers that each line of data comes from.

That array is then used in the Done button code.

Please Login or Register  to view this content.

Actually, I've got a question - do you want to deselect the items after you've updated them with Yes/No?

This is the code for deselecting.

Please Login or Register  to view this content.

Add that after the line(s) of code that set Yes/No.

Sorry, my mistake.

You need to replace I with idx, which is the loop variable in that code.

Don't know why I had I, probably force of habit.

That code isn't putting Yes/No on the worksheet, it puts it in the listbox

This is the code that does that.

Please Login or Register  to view this content.

Remind me, what range is the listbox populated with?

Off the top of my head it starts in column B, and if that's the case then column 16 in the listbox is column R.

So the code you posted should work.

Not quite sure I follow.

Do you want the existing Yes/No entries to appear in the listbox?

If you do that should be quite straightforward.

All we need to do is add code to populate a column in the listbox from column R on the worksheet.

Perhaps something like this.

Please Login or Register  to view this content.

Not sure if I've got the right listbox column so you might need to change that.

Also, I've used rng.Parent to refer to the worksheet the data is on.

The only reason I did that was because I couldn't remember the sheet name, you can just change it to Worksheets(<whatever>) if you want.