Hello all,

I am working on a model where the users can select from multiple data sets;
there are twelve different types of inputs. There are several different
data set providers (i.e. research organisation 1, research org 2), and they
may provide from 1 to 12 of the inputs. The purpose of the model is to allow
us to combine different inputs to see the effects on the output.

On the main output sheet, the names of the data sets are displayed and I
would like to color code the names of the inputs so that all inputs from
each organisation are the same color. I think I have worked out a way to
do this in the VBA procedure which I use to run the model using some useful
suggestions and code on the Internet (i.e. www.cpearson.com )

However, I would also like to add a user form to the model which allows the
addtion of data sets. I would like to enable users to choose a color code
for the data set from the list (ideally visually).

Does anyone have any suggestions about how this could be achieved?

Thanks,
Shane