Conditional formatting of a userform in VBA

[ilovelagar]

Hi everyone,

I have a VBA user-form that contains a check-list. I'm trying to figure out how to have that check-list change/alter based on certain cell data.

So suppose that the check-list has 10 options, and I have data in cells A1 through A10. What I would want is something akin to the following:

Example #1:
If cellls A1 - A5 contain data, then options 1 - 5 in the checklist turn red (as in the text turns red).

Example #2:
If the following cells contain data: A1, A3, A4, A8, and A10; then the following options in the checklist should turn red: 1, 3, 4, 8, and 10.

I'm just trying to figure out the basic premise as to how to do that; from there on I can expand on it and tweak it for my specific needs.

Any ideas

Cheers,

- I Love Lagar -

(PS. I actually love Guinness, which is a Stout, but "I Love Lagar" flows much better than "I Love Stout" )