Create a loop by defining X as integer, to shorten length of code

Hi guys,

I have some code which I know can be shortened by using a loop such as "Dim X as Integer" "from 1 to 50" "Next x", or something like that.

However, I have tried many variations of the code, and since I am a novice, I cannot get it to work!

This is a UserForm where I want to change the color of 'labels' based on whether the value in the spreadsheet in 1 or 0. Here is the code:

Please Login or Register  to view this content.

My labels go from 1 to 50, as do the corresponding cells T1 to T50. Instead of copying and pasting this code fifty times, how I do I create a loop?

Any help would be greatly appreciated! Thanks.

Thanks, this is working great!