Run code on any selection from validation list

[lukestkd]

Hello all,
I have a long piece of code currently attached to a button, but I would like to code to run whenever a selection is made from the dropdown list in cell C4 in the 'Feedback' sheet. The code starts

Please Login or Register  to view this content.

there is more code after that but I couldn't insert it here. Is there a prefix or coding for applying this to the validation list selection?

Many Thanks!

Luke

[patel45]

Please Login or Register  to view this content.

[lukestkd]

Hi Patel45.
Many thanks for your reply. The code is returning the error "Run Time Error: 13 Type Mismatch" VB is highlighting this section

Please Login or Register  to view this content.

[patel45]

did you put the macro on 'Feedback' sheet ? can you attach a sample file ?

[lukestkd]

Hi Patel45, yes I did put it in the feedback sheet. wb attached.

Cheers

[patel45]

Please Login or Register  to view this content.

[lukestkd]

working perfectly! Many Thanks!