<div>
 &nbsp; &nbsp;Range(&quot;C5&quot;).Value = &quot;John Doe&quot;<br />
&nbsp; &nbsp; Range(&quot;c5&quot;).AddComment<br />
&nbsp; &nbsp; Range(&quot;c5&quot;).Comment.Visibl<wbr />e = False<br />
&nbsp; &nbsp; Range(&quot;c5&quot;).Comment.Text Text:=Range(&quot;d5&quot;).Value
</div>


   Range("C5").Value = "John Doe"
    Range("c5").AddComment
    Range("c5").Comment.Visible = False
    Range("c5").Comment.Text Text:=Range("d5").Value

<div>
Beautiful! &nbsp;Thank you!
</div>


<div>
Thank you for your quick response.
</div>


<div>
<div class="content wysiwyg-content">
I have found a VBA program that will take the comments in certain cells and display them onto a separate worksheet - noting the cell reference number, the cell value and the comment. &nbsp;However, I would like to reverse this capability. &nbsp;I would like to take a row indicating the cell reference, the cell value, and the comment, and when I run the program, it will insert the comment to the very cell referenced on that row. &nbsp;For instance:<br />
<br />
Cell Reference &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cube/Office<br />
$C$5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;John Doe &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;South 112<br />
<br />
Running the VBA program would then go to the cell referenced C5, insert &quot;John Doe&quot; as its value, and insert a comment &quot;South 112&quot;.<br />
<br />
Is this possible?
</div>
</div>


I have found a VBA program that will take the comments in certain cells and display them onto a separate worksheet - noting the cell reference number, the cell value and the comment.  However, I would like to reverse this capability.  I would like to take a row indicating the cell reference, the cell value, and the comment, and when I run the program, it will insert the comment to the very cell referenced on that row.  For instance:

Cell Reference	Name	Cube/Office
$C$5		John Doe	South 112

Running the VBA program would then go to the cell referenced C5, insert "John Doe" as its value, and insert a comment "South 112".

Is this possible?

Excel - How to convert cell values into comments

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.