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


ADVERTISEMENT

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

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

Insert Comment Automatically When / Is Entered

Feb 1, 2013

How to make excel automatically insert a comment into a cell when a / is entered into that cell?

The comment needs to simply include the date the / was entered and nothing else.

View 8 Replies View Related

Automatically Open Comment Box When Data Is Entered.

Dec 22, 2008

I have a spreadsheet where we calculate lost time of machinery and how much money is lost. Every day someone enters the hours that the machines were down and then enters comment in that cell stating what happened or what the resolve was. So for example Machine A runs 24 hours a day, but 12-19-08 it had mechanical issues and was down for 2 hours, so the entrant will enter 22 in that cell, then have to right click back in that cell, go to insert comment and enter "need to change belts." Then if he finds out later that they were down another two hours he would have to change the hours, right click in the cell and edit comment. What we have been coming across is that after awhile he just enters the hours and not the comment. Besides firing a lazy operator I would like to make it more user friendly and ensure that the data entry person is entering the comment.

I would like after the hours are entered in the cell for the comment box to automatically open. I figured there has to be a formula to do it, but i am not at an advanced level. Can you help me?

View 14 Replies View Related

Macro To Make Insert Comment Window Appear Automatically

Sep 11, 2007

I have created an attendance tracker for a team of people at work. It simply involves a grid of the days of the month and on each 'day' (or cell) I have set up the Validation command to prompt the the user to select whether they were at work, on holiday, off sick etc. etc from a drop down box. If they do not change the cell, its defaulted value is that they are in work.

When a user selects the days that they are planning a holiday in the future, they are meant to write a comment on the cells they have changed, to advise when they had 'requested' the holiday.

What I would like is (a macro?) which makes the comment box automatically 'pop up' when they change a cell from its default value prompting them to fill in the details rather than relying on them to 'add comments' manually.

In addition, what would be the best way to 'restrict' them from booking holiday within the next 7 days - we have a problem with people booking holiday on 'lastminute.com' for 2 days time, booking off the holiday on the spreadsheet and saying that they had it planned for weeks!

View 9 Replies View Related

SumProduct With Different Sized Arrays

Jun 26, 2014

I want to take select records from one sheet and sum only the matching records from another sheet, but the ranges are different sizes. As an example, in Sheet1, I want to select the codes with a "Rank" of "1", and total the "Cost" of those matching codes in Sheet2.

I need a non-VBA solution.

View 14 Replies View Related

Code For Searching Different Sized Files

Aug 29, 2012

I have a macro that checks data in a worksheet and manipulates the data.

the problem that I am finding is that the worksheet data, which is copied from another file, is different sizes - eg: in one file the data may be from a1 to f2890 but another file the data may be from a1 to f5990.

When the file is bigger I have noted that the macro does not check the rows between 2890 to 5990.

How can i get it do check all the cells no matter how big the file is?

View 9 Replies View Related

Copy Variable Sized Range

Aug 8, 2006

A text file is imported to Excel Worksheet. I use this code to Select/Copy a section of that import;

Selection. Offset(4, 0).Resize(15, 9).Select
Selection.Copy
'The number 15 would mean there are 15 rows of items.

But there are not always 15 rows. There might be 18 rows, but because the code is set to 15 it will miss selecting 3 rows preceding, or if the code is set to 12 it will not select the full item list. However, whatever the amount of rows of items, be it 15,2 18 or 100 for example, directly under the item amounts is a "marker" purposely put in the file before the import for other search functions.

Above that marker is the total Item count! So I need a code to search for that marker, then move up 1 cell and whatever that number is, if "15" would then determine the correct row count to Resize

The "marker" is : ^3^

So the full code is:

Macro1 ()........................

View 8 Replies View Related

Macro To Select Variably Sized Range

Feb 25, 2014

I have a macro that contains a line:

Range("BB1011:CX1064").Select

The number of columns selected remains the same, but the number of rows changes. The indicator that tells me how many rows to select is contained in cell F1007 and in this example contains "54".

How do I adjust the macro to change the number of rows to select dependent on the value in F1007?

View 6 Replies View Related

Create Document With 3 And 4 Columns That Occupy Same Sized Area?

Apr 30, 2014

One of my coworkers is trying to create a document that has 3 columns in one part of the spreadsheet, but further down on the page, he needs to have 4 columns but wants them to use the same amount of space as the three columns. I have looked around and don't see how that is possible.

View 2 Replies View Related

Finding Withing Part Of Unknown Sized Column

Jan 12, 2008

im trying to find and delete records within a column if they occur twice. this works great right now but I want it to exclude the top 8 rows... i think it might have something to do with the LookAt:=xlPart constraint ...

View 4 Replies View Related

Copy Variable Sized Row And Paste Select Columns Into Different Worksheet

Sep 29, 2012

I'm in the middle of building a code that will look at the value in Sheet: "DATA" column "J", for each row that matches a criteria that I pull from a cell - Sheet: "Test" Cell: "C1".

The number of rows varies. I want to paste columns: "I2, K2:P2, U2:AJ2" when the value in Sheet: "DATA" column "J" matches the cell "C1".
I'm using a Command button to click every time I want to generate the filtered data. And I would prefer the code to always copy data starting at Sheet: "Test" Cell: "K2".

I've copied, below, my test code that I have so far which only copies row 2 from the Sheet: "Data", and copies it into Sheet: "Test", starting at K2.

VB:

Private Sub CommandButton2_Click()
If Sheets("DATA").Range("J2").Value = Sheets("Test").Cells(1, 3) Then
Sheets("DATA").Range("I2,K2:P2,U2:AJ2").Copy
Sheets("Test").Cells(2, 11).PasteSpecial Paste:=xlValues, Operation:=xlNone
End If
End Sub

View 3 Replies View Related

Publishing From Excel Document To PDF Produces Differently Sized Pages

Feb 13, 2014

When I publishing from Excel document to PDF it produces differently sized pages as shown in attached. Is there a way I can achieve a same size page view without having to change the font size and page layout of the source Excel document?

View 4 Replies View Related

Run Export Macro On Different Sized Ranges In Every Worksheet With Same Starting Cells?

May 12, 2014

I have a macro that I run repeatedly in a certain type of spreadsheet that does an export on a selection, pulls up a "Save As" message box and saves as a text file. There are 9 sheets in the workbook that contain the same data analysis for a set of samples, the only difference between them being the number of data (e.g. some may have 1500, 1400, 1600, etc.). I only select three columns of data to export (I6:K????) that contain counts (1,2,3,....), x-coordinates and y-coordinates. The counts column (I) uses a formula that only counts if there is an x-coordinate next to it (Col J).

[Code].....

Generally, what I do to make quick work out of selecting the variable ranges is to select Sheets 03-11 (the first nine sheets) and select K6:I6 (starting w/ K6). Then, on each individual sheet, I do CTRL+SHIFT+DOWN to select all the relevant data (if I started my selection with I6, then it would select all cells that contained formulas which may or may not have x,y-coordinates adjacent to them). Once the data is selected (I6:K????), I run the export macro and save the data as text. I would like a macro that can automate the selection for each Sheet 03-11, excluding Sheets "all", "data" and "summary", and run the export macro, first prompting me for a file location and a file prefix. When the text file is saved, it uses the file prefix and Worksheet name to build the filename, i.e. "pathprefix_wkshtname".

I've attached an example workbook : 20120511_Au-cit_pH5_test.xlsx‎

View 7 Replies View Related

Run-time Error '1004' :: Merged Cells To Be Identically Sized

Nov 14, 2006

What Im doing is sorting one page and copying the information to another page in the same workbook. But I keep getting this stupid error.

Run-time error '1004'
This operation requires the merged cells to be identically sized.

View 9 Replies View Related

Excel 2007 :: Macro To Insert A Text Box Auto-sized To Fit A Cell?

Nov 30, 2011

I am trying to write a Macro that will insert a Text Box that auto-fits the shape of a cell to hide its content. Once finished, the Macro will need to lock the cell and the text box so the contents of the cell are hidden. The idea is that I want to share a spreadsheet with someone but want to hide individual cells for various reason.

Sheet1A1SAMPLE DATA2sample3sample4HIDDEN5sampleExcel 2007

I tried to record a macro as a starting point but it recorded nothing. I searched around and it seems to be an issue without a solution.

I could obviously change the formatting and the contents of the cell but the idea is to preserve the contents if possible.

View 4 Replies View Related

List Boxes, Combo Boxes???

Jul 26, 2006

I am developing a spreadsheet with numerous information on our different suppliers offices in the country for each of our outlets. I am tryin to define a way to do the following:

If a colleague selects a company another list will appear with the region and when the region is selected a list of the offices will appear.

View 3 Replies View Related

Combo Boxes Based On Other Combo Boxes

Feb 1, 2007

I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.

View 2 Replies View Related

Check Boxes Macro: Macro That Will Check If The Boxes Are Checked And If Not Ignore Them And If So Run A Certain Macro

Jul 28, 2006

I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.

View 6 Replies View Related

If Comment Then End

Apr 25, 2006

I am trying to to get it to work so that if there is a comment already in the cell then it would skip to the next macro. Here is what I am trying:

'Mgr Voids
If Range("F9").Comment.Text = True Then End
ElseIf Range("F9").Value > 50 Then
MyInput = Application.InputBox("You Must Give A Reason For The Amount Of Mgr Voids For " & Range("F6"))
ElseIf MyInput = "" Then End
ElseIf MyInput = False Then End
ActiveSheet. Unprotect ("13792468")
ActiveSheet.Range("F9").AddComment
Range("F9").Comment.Visible = False
Range("F9").Comment.Text Text:="" & Chr(10) & (MyInput) & Chr(10) & ""
ActiveSheet.Protect ("13792468")
End If




The first part (If Range("F9").Comment.Text = True Then End) obviously doesn't work because I have no clue how it supposed to be... I was just hoping to get lucky. Any help would be appreciated.

Thanks,

Shawn

View 8 Replies View Related

Passing Old Value's To Comment

Apr 27, 2007

I am building a tool that uses Pivot Tables (so I can't use track changes) and I have found cool code that will insert timestamp and username in the comment when a change occurs. But I need to modify the code to also take the old value and put it into the comment as well. Here is the code to register the change into the comment:

View 11 Replies View Related

Force Comment

Jun 21, 2007

Is it possible to trigger a forced comment if a particular value is entered in a cell?

For instance, if the letter "F" is entered into a cell, I want the comment box is pop up, is this possible?

And lastly... is it possible to automatically group comments? for instance if a row has 6 comments, I'd like to combine all of them into a comment box on the same row.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved