how to make userforms pop up depended on value enter

hi all

i have some code that when the user double clicks a cell in range eg h1:h174 it pops up userform 2 so user can fill cell from combo box but i would like it to check a value. for example if i had value "head" in c1 when i go cross and double click h1 i would like userfrom1 to pop up and if i enter vaule "block" in c2 and the go cross to h2 and double click cell i would like userform 2 to pop up and if i enter value "crank" in c3 and the go cross to h3 and double click cells i would like userform 3 to pop up and if i enter value "preset" in c4 and the go cross to h4 and double click cells i would like userform 3 to pop up

thanks in advance here my code:

Please Login or Register  to view this content.

hi thanks for your quick reply
basically i would like it to check coresponding cell eg even if i enter head in c174 i would like userform 1 to pop up if i double click h174 so before userform pops up i would like to check value in c column same row to which what userform should pop up hope you understand thanks for help you legend

shane

thanks Norie you total legend

shane