Not really sure at all how I would go about this so would greatly appreciate and help and if you could break the code down for me so I can edit it for my other ranges I need to apply it.Ĭode i've got so far (tried to record the macro not 100% sure what the last line is doing). I'm not very good with VBA but I know how to write the select, copy and paste and even add a note to a cell but not in the format I wish like above. I would like K5 in Monthly Totals to have a comment saying: Hi x 10Īs shown one below the other so i know they're from different cells. I would also like the cell value in H5 to be on one line and the value of H6 on another line.įor example, if H5 and H6 in the Current Total breakdown tab are equal to "Hi x 10" and "Hello x 20" respectively: I wish to copy cells H5 and H6 in this tab into the note on cell K5 on the Monthly Totals tab. I have the tab - Current Total Breakdown. This note should be the cell values from a different tab. Windows macOS Web Android iOS Windows Mobile. When you hover your cursor over the cell, the comment appears. When a cell has a comment, an indicator appears in the corner of the cell. I wish to use VBA to add a note to a cell. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |