Loop for cycling through names of Lists in a UserForm

Hi,
This is in connection with a UserForm (although perhaps it can be considered a general problem!)

I have a number of Lists (named ListA, ListB, ListC etc.) in a Userform. I wish to add something to a list if it meets a condition. I wish to cycle through all of the lists using a loop.

So if we assume that the thing we are adding is a Variable called theActivity, then the long way would be to type out would be:

Please Login or Register  to view this content.

etc.
I wish to replace the letters (A-F etc.) with a variable, Letters.

I thought something like this below would work...

Please Login or Register  to view this content.

...but clearly it's not right and needs to be joined first or another approach is required!!

I would be very grateful if someone could enlighten me as To what approach I should adopt?

Thanks for reading my question!

John

Maybe like this

Please Login or Register  to view this content.

Agreed with stnkynts, but I think your Chr will return lower case letters, not the uppercase letters that are in your lists. An easy way to return capital letters, and not have to look up ASCII codes:

Please Login or Register  to view this content.

Bang on stnkynts - Thank you! :o)

Can you possibly explain why I have to use "Controls" in that case

Please Login or Register  to view this content.

, but I don't need it if I am just using

Please Login or Register  to view this content.

John

Thanks Walruseggman.

It worked in spite of not being a capital, but I appreciate the correction - and learning an alternative way!

I actually meant to write

Please Login or Register  to view this content.

which would give me a capital letter too!

Can you possibly explain why I have to use "Controls" in that case

The way you had it you were indicating, through the use of quotes, that your parameters were strings. Quotes indicates a string. So you were misidentifying objects and commands as string (ex "Me.List", ".Additem")

Listbox, Checkbox, CommandButton, etc are all objects on the UserForm. The UserForm has a parameter to access those objects, called Controls. So for the objects on a userform these are comparible:

ListBox1 = Me.Controls("ListBox1")
ComboBox1 = Me.Controls("ComboBox1")

You cannot use the shortened ListBox1 directly with a variable (i.e ListBox & i = doesn't work) but you can with the Controls parameter (Me.Controls("ListBox" & i) = works)

Clearly and concisely explained - Thank you again stnkynts!