excel userform / combobox with dependent list
Posted on 2010-09-13
I have a combo box on a userform that the user can choose a colour, e.g. red, green, blue etc. how do i create a dependent list so that when colour red is selected, the number 4 writes to sheet 1 instead of the colour?. THe users do not know the codes/assigned number but do know the colour. Can a dependent list be created on a userform? If so, how and how can i force the code to write the number rather than the colour?
This is a very simplified dummy example as I can't post the spreadsheet due to confidentiality.
My list is as follows:
Colours / Code