Stuck on this mullti select listbox issue

[Ghostrider757]

I have been trying everything on the internet for the last 2 weeks to find a solution to a seemingly easy problem. Maybe I am looking down the wrong path. Hope someone can chime in with some advice. Heres what I am trying to accomplish.

I have a userform multiselect listbox populated by rowsource in VBA that shows 12 columns per row (It intentionally does not show the 13th column). I would like to add the letter "X" on the 13th column in the same row (which is not shown on the listbox) for each item in the listbox that is selected and applied by a commandbutton click, Here is a quick mockup.

excel.PNG

I just for the life of me cannot figure out how to accomplish this in each selected row. Can anyone help me?

[bakerman2]

Use the Listindex of the Listbox to refer to the row of each selected cell.
Remember that ListIndex starts at 0.

[Ghostrider757]

Use the Listindex of the Listbox to refer to the row of each selected cell.
Remember that ListIndex starts at 0.

Thank you!

Here is what I have come up with. It seems to determine if rows are selected or not correctly, not sure about multiple vs single rows though. How do I go about selecting the 13th column of the selected rows and inputting the "X"?

Please Login or Register  to view this content.

[bakerman2]

This will give you an idea.

Please Login or Register  to view this content.

[Ghostrider757]

This will give you an idea.

Please Login or Register  to view this content.

That did the trick! I appreciate the help more than you know!

The only issue I have now which is my fault, is I failed to mention I was using an autofilter to place data on a helper sheet, so the code you provided only works half the time. It would work correctly if I had the autofilter set correctly. I have to figure a way to get rid of the helper sheet and populate the listbox using the autofilter where it only selects rows without the "X" directly on the worksheet where the data is contained.

[bakerman2]

Made you an example file so you can follow what's happening.
First we load entire dataset in Listbox, add an extra column in which we put the rownumber for each row of data. Next we filter out all green rows from dataset in ListBox.
Select the rows you want to mark and apply.

[Ghostrider757]

Made you an example file so you can follow what's happening.
First we load entire dataset in Listbox, add an extra column in which we put the rownumber for each row of data. Next we filter out all green rows from dataset in ListBox.
Select the rows you want to mark and apply.

Thats execllent!! I applied it to the sheet I am using and removed all my excess sheets etc to simplify things. I am attaching the file if you do not mind reviewing. The problem I am having is that when a row in column 13 gets the "X", it is correct on the worksheet but is still displayed when I open the userform again. It appears that

Please Login or Register  to view this content.

is getting in the way. I attempted to change the code around to remove the rows in column 13 on the userform that had an "X" but it didnt work. The reason I am looking to do this is when the "X" gets applied, conditional formatting will gray out and strike through the text. Any ideas?

[Ghostrider757]

It wont let me post the file for some reason.

[bakerman2]

To the bottom right of Quick Reply select Go Advanced. Scroll down to Manage Attachments.
Select your file, Click Upload, Click Close Window.
Submit Reply.

Edit:
Didn't read your reply carefully so I missed filtering on rows with X.
Amended code should take care of that.

Please Login or Register  to view this content.

[Ghostrider757]

To the bottom right of Quick Reply select Go Advanced. Scroll down to Manage Attachments.
Select your file, Click Upload, Click Close Window.
Submit Reply.

got it! thanks! i attached it here.

[bakerman2]

Did you try the amended code in my last post ?

[Ghostrider757]

Did you try the amended code in my last post ?

No I did not, I did not see it, but I will try it as soon as I get back from dinner.

[Ghostrider757]

Did you try the amended code in my last post ?

Was able to test it. Works perfect! I thank you so much! I have always managed to figure out how to make things work as intended, this one, I never would have been able to do on my own. Much much appreciated! I wish I could keep the column heads, but it is my understanding you can only have that if you use the rowsource, which I am not.