Message box display by selecting checkbox

[sumonrezadu]

In my excel sheet I have 3 checkbox. I need message box to display when checkbox is checked. Suppose when I mark check of checkbox1, a message box will display "the worst performer", when I check checkbox2, there should come a msgbox reading "the best performer".

Is there any one to help me. FYI I use excel 2007.

Thx

[Simon Lloyd]

Are you sure you want a message box or a textbox to appear, whichever one you will have to use vba, the advantage of a textbox is it cant be dismissed, you'd need to uncheck the checkbox to hide it again, a message box needs the ok to be clicked in order for it to go, textboxes can be edited on a non protected sheet message boxes can only be edited in the VBE