assign macro to activeX combo box

Hi - I would like to assign the macro below to an activeX combo box.

I am right clicking, view code and inserting the macro code between Private Sub ComboBox1_Change() and End Sub, however, to no avail. what am i doing wrong please!

Please Login or Register  to view this content.

Your event code should look like,

Please Login or Register  to view this content.

thanks andy - thought so. this isnt the problem then!!! cheers mate