![]() ![]() THEN go to a cell and and add a COMMENT (not a note) and you'll see that the macro isn't picking it up. Then modify one of the NOTES (he calls them comments) Run the macro again, and you will see the change. To see the difference, download his spreadsheet, and run the macro. Now I am looking to modify that macro to get the actual threaded COMMENTS. ![]() The degree symbol can be entered in cells, equation blocks or text boxes. A custom number format can be applied to cells and would apply the degree symbol as a format rather than inserting it. ![]() Private Sub WorkbookOpen () Dim ws As Worksheet Dim rg As Range Dim comment As String Dim i As Integer i 1 Set rg Range ('E1:E10') set range of where the comments will be seen Set ws Sheets ('Sheet1') For Each c In rg comment ws.Cells (i, 2).Value. You can insert or type the degree symbol in Excel using built-in commands, keyboard shortcuts or a custom number format. (I don't think it has anything to do with the former president ) Make sure to first add a comment for the cell range first. xlsm spreadsheet containing examples, the code itself, and even a button to invoke the macro. If you wish to list all of the NOTES in an Excel 365 worksheet, the following URL does a great job of explaining, and even has a downloadable. While there are different Excel versions, adding comments in all the versions is done in almost the same way.To add a comment to a cell, start by placing the cursor on the cell you want to add a comment, right-click on the cell, and scroll down the list to the Insert Comment command. list all of the comments in a worksheet.) My problem was the same as others who discovered that Excel now has a new threaded category called "Comments" and the old category that used to be called "Comments" is now called "Notes" Was looking to do the same thing as you (i.e. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |