This is copied from a question i put in the discussion group excel general
which i think was the wrong group.Apoloies if this was ot the correct thing
to do

I am new to VBA and am trying to do the following, I have created the
Userform and check boxes but that is as far as i have got.

When a ceratin a cell e.g A1 goes to = red then a userform will pop up with
a list of check boxes e.g Nexus, G2, Swift, Crest if Nexus and Crest check
box is ticked then the word nexus will appear A2 and Crest in A3. Or if G2
and Swift were checked then G2 would be in cell A2 and Swift in cell C3.

Many Thanks

Simon Jelinek