Hi everyone,

I'm definately not an expert at this stuff so your help would be
greatly appreciated.

I'm creating a scheduling sheet that has several hundred comboboxes
populated with three choices: "Assigned", "Unnassigned" and
"Completed". I also have the background color change depending on the
choice. The only way I can figure to do this is to manually create
the code for each combobox and it's proving far too much work with
this many fields.

Could someone post some code I could try that uses a loop or array or
something? It's been several years since I've done any programming
and I just don't have the time to figure it all out again!

Thanks in advance!

Regards,

Sean M.