Hi spydor,
Is this what you mean?

http://hanjohn.customer.netspace.net...get%20test.xls

I've named A1:A20 Work_Area and AA1:AB6 Data_Area.
Work_Area has Data Validation which is the list of Values in AA1:AA6 ie
different coloured Widgets. The required Widget constants are in
AB1:AB6.
The Sheet1 module has the Sheet_Change Sub which first checks that the
change occurred in the Work_Area and then goes on the change the Target
cell value to the appropriate widget constant via the VLookUp worksheet
function.
Ken Johnson