|re: "I would like help with a VBA solution"|
Do you want help with something you already have tried or are you asking us to provide a solution?
Is there a specific column that you want this to happen in or do you want it happen anywhere and everywhere you select a cell?
Do you want it to be "automatic" i.e. create the comment as soon as you select a cell, or do you want to the option to run the macro only when you choose to?
Keep in mind that we can't see your spreadsheet from where we're sitting so you have to be specific about what you are trying to accomplish.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.