Automated Cell Comments

[Deek61]

Hi all

I am setting a roll for work personnel and would like to automate as much as possible. Adding various comments in a cell depending on what is inputted into the cell will save me a fair amount of time. I am running excel 2010 and I have set up conditional formatting to modify the cell appearance when L, S, CL, CN, CP, DEPLOYED etc is entered into a cell. Eg when CN is entered the cell changes color but I would like a comment box to open with course name & date is already in the comment field ready for additional input from myself. I would prefer that when CN is entered and a comment is entered that this comment does not change when it is changed to CP. I am unsure whether this is possible. Any assistance would be greatly appreciated. I would also like for the text to automatically change to uppercase irrespective of whether upper or lower case is selected on the keyboard. Please find attached a sample of my database. Cheers Derek

[Simon Lloyd]

Hi, you didnt supply a workbook but if you put this code in the worksheet code module and adjust it or extend it to suit, it should get you where you want to be:

Please Login or Register  to view this content.

[Deek61]

Sorry for not getting back to you before now. Thank you for the detail supplied it did in fact do what I was looking for.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Simon Lloyd]

Sorry for not getting back to you before now. Thank you for the detail supplied it did in fact do what I was looking for.

Haha, almost 10 years ago!, glad you finally got it to work 🤣