Hi All

Is it possible to create a form and depending on what a user puts in a particular field, a smiley, straight or sad face is returned. It would be ideal to have these faces in their respective green, amber and red.
I've seen it done on a work sheet and had a go with the help of this thread using conditional formatting. I have a basic understanding of forms and vba, but if anyone had come across this before and/or has the code, it would be a real life saver.

Essentially i'm trying to capture data from colleagues through a form, but i really want to be able to give them some initial feedback on their responses.

Thanks for any advice you can give

Ben