comment cell

Im trying to create a macro that comments based on another sheet I set up with the text in proper order (ie. A1 on Comment Sheet has Comment that should be in A1 for Sheet 1 and so on). I'm struggling with automating this one, does anyone know how to do this?

Hi there. I'm attempting to create a user-friendly macro-enabled spreadsheet ("Comments Recap v2.xlsm") that will generate a report of the Excel cell Comments in selected Excel workbooks. I've got a nifty button that will enable the user to select a folder. After that, all the excel files...

Dear all, I've been using the website for long time now, always finding the resources I needed to keep on building my sheets. However I have been struggling with the following for a few hours, and can't find a proper answer, anywhere, so far... Situation: I have a whole sheet of numbers, used...

Hi There I'm trying to display a comment box automatically when a particular text is selected from the drop down list. For example, when a user selects "Add on card 1,2 or 3" from the list, a comment box to appear with the following.. "Check if you need low or high profile card". See link...

Hi all, Any help on this would make my day :) I need a macro that places the result of the formula of e.g. cell B6 to the Comment box of e.g. cell D6. (Old values within the Comment box have to be removed first) Thanks, Theo