Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Create and edit a comment

0

This comment appears whenever I click the cell "Teljesites" above it.

It can be moved wherever on the sheet but can not be deleted or edited.

It does not appear to be a real comment showing up "edit comment " at right click.

On right click I get "insert comment" as it had no comment at this cell yet.

It can not be deleted until I am on that cell. It is at first row and at some of the second.

How is it to be edited/deleted or a new onr created?

Thank you,

Istvan

Answer
Discuss

Answers

0
Selected Answer

The cell L2 has "Data Validation", meaning there are restrictions as to what you can enter in that cell. The "Comment" you see is the "Input Message" associated with the validation setup. To set, remove or modify the Data Validation click the Data Validation button in the Data Tools meno of the Ribbon's Data tab and select Data Validation to open the related dialog box.

You can edit the text of the message on the Input Message tab of that dialog. You can give it a title which will appear bold in the message, or you can delete the message in which case there will be none although the validation will still be active. Actually, the message indicates that a date should be required and Validation should reject when a non-date is entered. But on the Settings tab you can see that Any value is selected and that means that there are no restrictions. You are right: the iinput message serves no purpose. If that is what you want, delete the entire Data Validation which will also do away with the message. There is a Clear All button on the Settings tab for this purpose.

Discuss
0

Thank you ! It is solved.

Regards,

Istvan

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login