I know this should be easy but annoyingly it is getting the better of me . Basically I have a list of words held in a listbox and when (the listbox is set to multi select) more than one word is selected I need to add this to a string variable and each word (but not the last one) needs to be separated by a comma and then the last word needs to be separated by the word and .
So at the moment this is triggered by a listbox on clicked (I have also tried on select change as well) and then I have added a sub event from this with the condition listbox.selectedcount>1 then using a for loop add each selected word to the variable adding a comma on the end but no words are added when I do this.
Is my logic correct ? If so it must be how I am going about this. This is a large project to add as a capx file as there are other event sheets involved here doing other work within the project but if someone could point me in the right direction I would appreciate it