Comment Boxes Change Size And Location?

Sep 16, 2013

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 Replies


Change Default Comment Box Size

Oct 14, 2009

I 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 Related

Change Default Text Size On Inserted Comment

Sep 26, 2009

Is 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 Related

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how 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.

View 6 Replies View Related

Add Multiple Comment Boxes

Sep 26, 2007

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 Related

Adding Comment Boxes

Dec 19, 2006

I 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.

View 9 Replies View Related

Moving Comment Boxes

May 26, 2006

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

Comment Boxes Were Automatically Re-sized

Jul 16, 2008

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?

View 9 Replies View Related

Combining Text From Comment Boxes

Apr 25, 2013

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 Related

Comment Boxes On A Protected Worksheet

May 22, 2006

I 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.

View 9 Replies View Related

Print Track Changes Comment Boxes

Aug 16, 2007

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 Related

Comment Box Size - Macro

Apr 12, 2007

I 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

View 9 Replies View Related

How To Adjust The Font Size In A Comment

Oct 26, 2013

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 Related

Resize The Comment Box To The Size Of The Text I Put In?

Apr 2, 2009

when 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 Related

Excel 2007 :: Comment Boxes Not Showing To Near The Related Cell?

Dec 9, 2012

I 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 Related

Increase Size Of Dialog Boxes

Jun 6, 2008

Is 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 Related

AutoFit Size Of Comment Box Of Selected Cell(s) To Its Content

Jan 18, 2014

I 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.

View 4 Replies View Related

Amending Chart Location And Size

Aug 17, 2005

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.

View 9 Replies View Related

Increase Size Of Dialog Boxes In Excel?

May 8, 2012

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 Related

Specify Size And Location On Screen Of Notepad Opened By VBA?

Feb 15, 2010

I'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.

View 8 Replies View Related

Drop-down Boxes Make File Size Too Large

Aug 31, 2009

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?

View 3 Replies View Related

Change Color Of Comment Icon

Apr 22, 2014

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 Related

Change The Color Of The Comment Indicators

May 11, 2006

how 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.

View 14 Replies View Related

Change Comment Line Color

Feb 12, 2012

The comment lines in Exel VBA editor is green by default, is it possible to change the color?

View 2 Replies View Related

Excel VBA - Add Comment On Change To Cell Value

Oct 1, 2012

I 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

[Code] .......

View 1 Replies View Related

Comment Change Event In A Cell

Apr 26, 2014

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 Related

Change Comment Box Shape And Make It Default

Jul 1, 2013

i 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 Related

Change Cell Location

Aug 7, 2012

I 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 Related

Change The Folder Location

Dec 14, 2006

which 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.

View 9 Replies View Related

How To Change Text In Saving Boxes

Mar 26, 2014

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

Copyrights 2005-15, All rights reserved