macros for comments

[mkogut]

Is it possible to create macros that would allow one to enter a few characters in an excel cell and have a description for the entry be automatically entered into a comment box?

 

[mikerickson]

It would be easier if the "comment" were to go into the cell to the right.
Reacting to what is entered into cells is what cell formulas are designed for.
Comments are not designed for that purpose.

Yes, it could be done, but not a easily or as well as a cell formula could do it.

What macros have you tried? What problems are you having with them?

 

[mkogut]

I haven't tried anything as I do not know how to do so. Would it be possible to have the comment go into the cell below? What I am trying to get to is a means of placing characters in sequential cells in a row that would allow quick reading of the information being entered. If one knew what the characters meant it would negate the need to read the explanations that the comments provided. I one did not know the "code" provided by the characters, the needed information would be readily available. Thank you for your reply to my question. I have been asking about this possibility for many years. Just did not know who or where to ask.

 

[mikerickson]

What you could do is put a Vlookup chart on another sheet.

Suppose that you have this in Sheet2!A1:B5

Code Explaination
Be blue
Bk black
Br brown
Gr green
Gy grey

then if "Gr" were in Sheet1!C1 then the formula
=VLOOKUP(C1, Sheet2!$A$1:$B5, 2 ,False) would return "Green" to the cell that held the formula.

Lists like this tend to change and formula need adjusting (probably in about 3 months).
Using techniques that one is familiar with makes that maintenance easier.