The comment boxes keep changing shape and location in my spreadsheet. Some are completely smashed together, while others are extraodinarily wide. I had them all to the right of the cell they applied to; but now they are all over the place.
View 1 RepliesI need to default size to be bigger. Is there a way to do this so I do not need to re-size the box every time?
View 2 Replies View RelatedIs it possible to change the default text size on comments I insert throughout my spreadsheets? I have to enlarge 100% of them.
View 2 Replies View Relatedhow to copy the contents of multiple comment boxes and paste in a single comment box.
The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.
I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.
This is a repost, I would like to add a comment boxe in multiple sheets (same cell) in a work book. Someone reccomended a macro but then my post was removed.
View 12 Replies View RelatedI am trying to write a VBA macro that will go from one sheet and copy a cell's text, then go back to the main sheet and insert this text into a "comment-box" type of thing.
The box I'm talking about is where you move the mouse over a cell and a box pops up with the comment in it.
Is there an easy way to move a comment box? I have a comment box on a specific cell (hidden until mouse is hovering over it). Each day when new data is filled in, I need to move the comment down to the next cell. Right now, I click on edit comment, copy the comment, then click insert comment in the other cell, paste comment....then delete the old comment. Is there a way to just move the comment down to the next cell?
View 5 Replies View Related I have a document with about 300 comment boxes, and I needed to enlarge each one to make the information visibly fit in the region. I did this, and was happy.
Then I opened the file on another computer, added a few rows, saved the file, and re-opened it on this one, and all the comment boxes in the original rows (the 300 i had, not the 15 I added later) had been reduced in size and not all the text is visible. Why did this happen? Is there an easy way to re-size all the boxes without doing them one at a time?
I am trying to combine the text from the comments boxes of a full row of cells into the comments box of a separate other cell in order to provide an overview of the comments in these cells in one place.
View 2 Replies View RelatedI am being asked to create a workbook where 80% of it is protected. And user input is restricted to specific columns and rows.
However the user wants column R unprotected so that Comment boxes can be used, but when I protect the workbooksheet the Insert option is not available when you right click.
Is it possible to print a workbook and have the "track changes on screen" show on the hard copy? I'm using Excel's track changes option to monitor changes to a workbook. I've selected the box "Highlight Changes on Screen". I would like the box containing the change (which pops up when you hover your mouse over the cell) to print out with the workbook so users can see what was changed when reviewing the hard copy. This is preferable to using the "List changes on a new sheet" option since it would require flipping between multiple pages.
View 5 Replies View RelatedI am using the following macro to creat comments based on the contents of certain cells. Everything works except the it resizes the Comment Boxes exponentially. The Last comment box in the range seems to be the default size, the next to last a little bigger, then it start getting even larger and larger until the first comment in the colomn.
Sub InsertComm()
Dim RgPartnumb As Range
Dim NRg As Range
Set RgPartnumb = Range(Range("B2"), Range("B2").End(xlDown))
On Error Resume Next
For Each NRg In RgPartnumb
With NRg
.Comment.Delete...................................
Is there a way to adjust the font size in a comment. The default seems way to small. All thoughts on the subject .
View 4 Replies View Relatedwhen i use a macro to add a comment to one of my cells, if i put in too much text the box doesn't resize itself and you can only read part of the comment. how to resize the comment box to the size of the text i put in?
View 2 Replies View RelatedI have worksheet with 5000 rows data's including the comments in one coloumn.My problem is when I edit the comments,the comment box shows somewhere else is not showing to near the related cell.I am using excel 2007,its happen after the upgradation of 2003 to 2007.
View 2 Replies View RelatedIs there anyway to make the box size of the wizard larger? I am having a hard time telling where to place my splits in the little wizard box.
View 2 Replies View RelatedI am wondering within the Excel interface, is it possible to auto-fit the size of a comment box to its content?
I have searched the internet and found that a macro as follows could do the job:
Sub FitComments()
Dim c As Comment
For Each c In ActiveSheet.Comments
c.Shape.TextFrame.AutoSize = True
Next c
End Sub
However, this Macro applies to and resize all of the the comment boxes in the active sheet.
I would like to just auto-fit the comment box only to the selected cell, or even better, to multiple selected cells.
I have craeted a chart in VBA, which sits in the middle of the page . I have attempted to move it to a new location with the following code
ActiveChart.Parent. Name = "MyChart"
ActiveSheet.ChartObjects("MyChart").IncrementLeft -237.75
ActiveSheet.ChartObjects("MyChart").IncrementTop 32.25
ActiveSheet.ChartObjects("MyChart").ScaleHeight 0.96, msoFalse, msoScaleFromTopLeft
ActiveSheet.ChartObjects("MyChart").ScaleWidth 1.17, msoFalse, msoScaleFromTopLeft
which I adapted from a recorded macro, but which fails in execution, error message indicates that the Object does not support the property or Method.
Is there anyway to increase the size of dialog boxes in excel? I am vision impaired, when I go to "format cell" I have a problem reading it. If I could increase the font size, wouild make mt life easier.
View 2 Replies View RelatedI'm using this code to open a text file. Is there a method to specify the size and location of the window that opens with the textfile?
I'm sure there may be a better method to open the textfile, so feel free to tell me how bad this code is.
I'm using Excel 2007. I have a cell with a dropdown box that has the values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box.
This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function?
I want to know if we can change the color of the comment icon (when we add comment for a cell it gives a triangle form in red) can we change the color.
View 3 Replies View Relatedhow I can change the color of the comment indicators in an
Excel spreadsheet so I can tell who wrote the comment. This would help me and
my secretary to be able to do our work and be able to tell who's comment it
is. We are in different lacation and can't always talk to each other on the
spur of the moment. If we can change the color of the comment indicator then
it would be simple to be able to see at a glance who's comment it is.
The comment lines in Exel VBA editor is green by default, is it possible to change the color?
View 2 Replies View RelatedI am looking to have a select few cells generate a comment when the user changes their value. I don't want the entire sheet to be affected as it will only apply to the header row of columns J:P.
I'm not sure if it matters but I have the worksheet protected and the cells in question are unlocked.
Below is an example of the code I'm trying to get to work.
Option Explicit
Public preValue As Variant
Private Sub worksheet_change(ByVal Target As Range)
End Sub
If Target.Count > 1 Then Exit Sub
Target.ClearComments
[Code] .......
I want to write some code if a cells comment changes. Worksheet change doesn't fire if you right click a cell and edit the comment and save it. Is there an event that does fire when the comment changes?
View 2 Replies View Relatedi changed the shape of "Comment" box with edit shape. However when i right click the updated shape and click on Set Autoshape Default it does nothing. When I insert a new comment it is back to old shape.
View 2 Replies View RelatedI have a row b1, b2, b3, b4, b5 etc. I need to change it to c1,,c2,c3,c4,c5 etc. Is there a fast easy way to do it. I know about $ but I'm past that.
View 6 Replies View Relatedwhich part of this macro I need to edit to make it open a folder I want?
Sub OpenFolderRequest()
YesNo = MsgBox("Would you like to open the folder to see" _
& vbCr & "which files are currently there?", vbYesNo + vbQuestion, "Open Folder?")
Select Case YesNo
Case vbYes
myval = Shell("c:winntexplorer.exe c:winnt", 1)
Case vbNo
End Select
End Sub
I have tried changing the (c:winntexplorer.exe c:winnt) to the location name of the folder I want to open (S:Stock ControlSTOCK CONTROLOrder Confirmation)but it doesn’t seem to work.
I have a file that another person created and instead of traditionally saving, the only way to save file is by hitting X in top right corner and then a series of boxes pop up directing the user on what to do. I looked at macros within file and couldn't find anything really relating to the saving functions of document. This is a complex document and I'm starting to think that it isn't a macro. Is there any area in excel that allows you to adjust save settings? All I'm trying to do is change the wording in these pop up boxes but cannot find the source. Attached is screen shot of first box that pops up.
View 4 Replies View Related