drop down list for comment

[timlh42]

is there anyway to have a selection list to choose from instead of writing a comment in the comment box?

Here is what I would like to do:

If any cell in range H7:H37 , J7:J37, L7:L37 (which are populated by a validation list) is less than 5, then a comment box would pop up offering the following choices:

Too much time
Too late
Not enough teamwork
etc
etc

 

[timlh42]

Thank you! I did that and I stopped getting the error. However, after clicking the commandbutton1 it says to select a choice. When I click o.k., it just goes back to the spreadsheet and nothing else happens.

 

[DanteAmor]

Try my file, I put the link in post #10 to download the file.

 

[timlh42]

Perfect!!!!!

Thank you!!!!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.