auto comment based on cell entry

[dr mint]

I am trying to get an auto comment box to appear if a cell has data entered other than 10 ( if blank then no comment also). I aslo need the comment to be a forced option, ( a comment must be entered to proceed)
What are my options? Is this possible with excel?

[DonkeyOte]

A bit vague ... questions:

-- Is this to apply to a single cell or multiple ?

-- What happens if a comment already exists but value is subsequently changed to 10 - should the comment be cleared ?

-- How is the "value" of the cell altered ? Manually or result of formula ?


In short you would need to use VBA given you can not enforce the creation of a comment using native functions / functionality etc...


Points worth making perhaps:


-- Even with VBA Event intervention it will only work if the end-users have enabled macros in the first instance.

-- Regards enforcing the comment itself I think you would have to use a standard dialog (eg InputBox) and subsequently pass the text to the comment, removing Cancel / Ignore options at the same time
(note: this practice can be annoying for users if they activate the event by mistake as they can't cancel from it - ie they must go through the process of adding a comment)