cell comments

Hi, I have a workbook. First sheet has dates September 1st 2023 to September 30th 2023 (a2 to a31). I have 6 comments in each cell of each row. (columns B,C,D,E,F and G). The next 30 sheets are for the thirty days of September, titled September 1st 2023, September 2nd 2023 etc. Using VBA I want...

I have an Excel file with a VBA project that had been working just fine until recently. I have finally tracked the problem but it does not make much sense: At one point, the code within the Excel file opens another file to get a value—this second file is provided by an outside third-party. When...

I need help writing code to set margins within the cell comments themselves in VBA. I have found posts to set every other kind of margins, but not in cell comments. let me know if you know of any. For Each MyComments In ActiveSheet.Comments With MyComments .Shape.AutoShapeType =...

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. The goal is for my users to open my file, click a button, be promoted to select wither a single file or a...

I have seen several examples of how to read cell comments. I am doing it slightly different and I guess my syntax is wrong?? My line that tries to set sComment = Cells(r,c).Comment.Text does not ever grab the Comments from the cell. I'm hoping this is dumb format/syntax problem. DIM...

[Office 2007 and Office 2003] Is there no one else who has this problem??? I have searched this site and elsewhere on the web in the sites of several trusted experts and MVP's, and have even tried to find some help on Microsoft Community, even [gag] Microsoft Support, without success...

Hi, I'm new to VBA and need help. I have a workbook with 40 sheets in it that I need to protect. I'd prefer to do this all at once. Users need access into some of the sheets so I want to protect the sheets and allow them to select locked and unlocked cells...along with allow them the ability...

I have to combine the cell contents (values and cell comments) from one cell, to another cell (on the same row) that already contains a value and a comment. I can use paste special to add the values together (I don't need to retain the individual values) but I need to show both sets of comments...

Hi, Apologies in advance, for the length of the post ...it's long, but what I'm trying to do, I hope, is quite simple. I have a spreadsheet with a column (column A) of data where some of the cells in the column contain comments (i.e. the little boxes with text in that appear when you hover...

I've seen a couple of answers on here that I'd already figured out on my own so I thought I'd just post the question again and hope for more details. In Office 2003, I could select text in a comment and click the text color box in the toolbar to change the color of the selected text. It was a...

For a particular project, when a user logs in, a UserForm will appear for input on what procedures are needed from the Lab. The UserForm (frmInputProc) has 11 Check Boxes and a Text Box for Special Instructions. When the "Save Data" commandbutton is clicked, I would like Label from each...

I have a file where comments are used for some cells. The user does not insert any text into these comments fields, but uses the comments feature to display pictures. A picture is used for the fill pattern of the cell (inserted through fill effects) and that picture is what is displayed when...

I have a spreadsheet with over 1000 rows, with comments in 1 cell in each row. The problem is that the comment box is too small, and cuts off part of the verbiage. How can I resize all of them at once, so that everything in the comment field is visible?