Add Multiple Comment Boxes
Sep 26, 2007This 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 RepliesThis 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 Replieshow 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.
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.
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 RelatedThe 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 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 RelatedI need to copy data from multiple cells into a comment box. Right now, I'm highlighting each text in each cell and pasting into the comment box. So A1 data, I am going to the formula bar, highlightin the text and pasting individulally into the comment box.
Also, is there a way to merge multiple cells into one cell . I have text in cells A1:A14 and want all that data into one cell. Is this possible?
I have a manualy constructed user form which has 3 data validation lists.
Sources:
B7 = List 1
B12:B15 = List 2
B17:B20 and C17:C20 = List 3
These operate fine but I wish to replace the dropdown validation boxes and replace them with Combo boxes so that users are able to view the complete lists and also offer the option of inputting an item not included in the validation list if required.
I have tried many variations of input but my knowledge base is inadequate!
Mainly I end up with the combo box working on one cell only!
Can tell:
1. Do I have to raise 1 combo box per cell?
2. What vba code is necessary to make them all work?
I did away with the merged cells, and now I have a combo box in every cell that I want it in.
My problem is, I would like to format each combo box seperately. Every cell that has a combo box in it has data vakidation activated. I copy and pasted code to get it to work. It works great, but I would still like to change the combo box size and tab and enter functions for each individual one. I created more than one combo box but I kept getting an error on them. Any help or knowledge would be greatly appreciated.
I am posting just the code that I copy and pasted.
I have 10 Text boxes each, on many tabs of a Multipage. I have a Private Sub LoadRow() for one tab.Is there a way to use a Sub that would work for each tab or do I have to write a new sub for each tab? Here’s the sub I’m using.
Private Sub LoadRow()
txtTrussco.Text = Cells(lCurrentRow, 1).Value
txtTPhone.Text = Cells(lCurrentRow, 2).Value
txtTFax.Text = Cells(lCurrentRow, 3).Value
txtTAddress.Text = Cells(lCurrentRow, 4).Value
txtTCity.Text = Cells(lCurrentRow, 5).Value
txtTState.Text = Cells(lCurrentRow, 6).Value
txtTZipcode.Text = Cells(lCurrentRow, 7).Value
txtTSalesrep.Text = Cells(lCurrentRow, 8).Value
txtTSrepphone.Text = Cells(lCurrentRow, 9).Value
txtTrusseng.Text = Cells(lCurrentRow, 10).Value
End Sub
I am trying to add multiple lines in comment. problem is the text to this mutiline comments is stored in a range
Range("J15").Select
Range("J15").AddComment
Range("J15").Comment.Visible = False
Range("J15").Comment.Text Text:="Line1" & Chr(10) & "Line2"
(This is recorded). assuming that range "A1:A15" is where text for this comment is stored from a different VBA program.(15 number of line is the max i have programmed to accept). assuming there are 10 cells currenty full. how can i add this 10 text lines to a comment box.
Is there a way to a mass insert of Check Boxes without the cell link all being the same cell? I have a huge list of items that I want to put a check box next to each one. This way when my warehouse people check it off in the sheet one of the columns will read "Available".
Problem is when I put the first box in and cell link it to E4, and then copy and paste it, all the boxes toggle based on one another. Otherwise I have to put in 584 check boxes. Solutions or other recommendations are gladly welcome.
Also, is "True/False" the only available "response" when using Check boxes? (I Know I can write an equation based on the true false, but I am just curious)
I have dropdown boxes in cells B11,B14,B17,B20,B26,B29,B32,B41,B44 of my worksheet. I would like to use a command button that can reset all dropdown values to blank.
View 9 Replies View RelatedAdding ' in the beginning of a line converts the rest into comment line. I wonder if there is an easy way to convert a huge area into comment line to try something on code. I couldn't find such an option in the menu.
View 2 Replies View RelatedI'm trying to incorporate multiple conditional (Dynamic?) drop down boxes to enable me to get an appropriate code at the end of the process. This will be used to product data entry and the code will tell Amazon where to post the product. I have many thousands of codes that i need to access and the easiest and most accurate way is to break down everything in to category and sub categories until I eventually get the code I want for that specific product.
for Example:
1730708031Clothing/Baby/Baby Girls 0-24m/Hoodies & Tracksuits/Tracksuit Bottoms
To return this code I would want to select Clothing, which returns a list which includes baby which in turn will give me a list that includes baby girls and so on and so on until I can select Tracksuit bottoms that will return the code.
Each list is dependent on the previous choice
As I have thousand and thousand of potential codes creating range list for each potential category and sub categories is not really feasible and would be very difficult to maintain when changes occur.
With this in mind I have created a code list that breaks the above example so that each category is now in it's own cell and there can be upto 8 (as I've seen so far) potential conditional categories before you return the code and ideally I would like to use this as it very easy to create and update. (see attached)
I might be able to use filters to return the appropriate list each time but don't know where to begin.
ClothingCodes.xlsx
I have a userform within an Add-in. The form contains multiple text boxes, shown as a grid. When the user uses the calculate button - the text box in question is raised and highlighted using the follwing code within a case statement:
View 2 Replies View RelatedI would like to be able to create multiple check boxes that will accomplish 2 things.
1. When Checked will display a date in the cell one column to the right.
2. When checked will change colors
Secondly, since i will need to make several hundred of these I would like a macro that will allow me to define how the check box is to behave and then have a macro which will allow me to define all of the settings and then input the number of check boxes that I want and it will create that many boxes.
I recall seeing a macro on here some time ago (at least 1 month prior but no more than 6 months prior) which allowed you to type into a form how many check boxes or option boxes you wanted to create in your workbook, and then it would create that many.
I have many text boxes on a form and if any of them are empty then I want a msgbox to popup and exit sub. I know how to do the following
If txtExample1 is "" then msgbox and exit sub
if txt....2
if txt...3
Is there anyway to group the text boxes to test for empty so you don't have to list 20 textboxes
I'm working with Excel 2002 on Windows XP.
I want to select more than one drop down box at the same time, and copy them as well as rename the cells they refer to.
For example: in A1 there will be a box with LinkedCell set to A1 and ListFillRange set to B1:B5. I now want a similar box in A2, with A2 as LinkedCell. However, when I copy past the box in A1, it still refers to A1 and B1:B5 (the last part is ok). I can easily change A1 to A2 by just changing it in the properties, but the thing is that I also need these boxes in A3:A100. Is there any faster way of changing this?
Also, the ListFillRange might expand in the future. Therefor I would like to know if its possible to select the boxes in A1:A100 and change the ListFillRange to B1:B6 for all at once.
I have a userform with 40 text boxes in it. I have learnt how to restrict people entering anything other than numbers into a text box using the following code on the keypress property of the textbox:
Const Number$ = "0123456789." ' only allow these characters
If KeyAscii 8 Then
If InStr(Number$, Chr(KeyAscii)) = 0 Then
KeyAscii = 0
Exit Sub
End If
End If
Rather than have 40 of these blocks of code (one for each text box), is it possible to somehow group them so that a block of code is applicable to all of them?
For the sake of arguement, the textboxes are called data1 up to data40
I have a user form with 4 list boxes that I'd each like to populate with their own lists of cities according to time zone - one list box for each time zone (ET, CT, MT and PT).
I attached a worksheet that has some code from another project I got from another thread on this forum, but it needs to be modified (or whole new code written) for this application, including initializing the control buttons.
The code I'm borrowing has a slight glitch in it, where if you select the last item in the list box to hide, that item will be missing from the list the next time the user form is opened, and you'll then have to manually unhide that column.
I have 3 dropdown boxes I created using the control toolbox which pull corresponding information from 3 different columns. I would like to be able to format them so that upon data entry in the first dropdown box, the subsequent two boxes auto populate with the corresponding data. Currently I have to select the information for each dropdown box manually.
View 6 Replies View RelatedBasically I have a list of companies each with five corresponding check boxes in different cells. I want the cell with the company name in (or just a symbol in the cell) to appear Green, Amber, Red when 5, 3-4, 1-2 of the boxes are checked respectively.
View 3 Replies View Related> When the workbook is opened I want a box to appear with a message and 4 choices (as buttons?).
> Based on the button clicked I want 1 of 4 new boxes to appear (replacing the first box) and ask for input values.
>I then want the inputs to be written to specific cells on a specified worksheets inside the workbook.
I am trying to make a drop down list and based on what I select from the drop down needs to populate a different drop down list with information based on what I select.
For example: if I have Sheet1, Sheet2, Sheet3 and Sheet4.
Inside of Sheet4 (My Main Sheet) I have a Data Validation (Drop Down list) in Cell A5 and Cell B5
I would like to choose Sheet1 from Cell A5 and in that same sheet (Sheet4) in Cell B5 I want to have a drop down with a list of names that are located in Sheet1 in Column A:A.
Or If I would've picked Sheet2 in Cell A5 of (Sheet4), I would like to see a drop down with a list of names in Cell B5 (Sheet4) that are on Sheet2 in Column A:A . Is this possible?
So far I could achive it if information I want is located on the same Sheet. But I need it to work if info is located on different Sheets
As part of an audit program I have a questionnaire. One of the questions has 10 check boxes, one with a combo box and one with a text box. The user will check at least 2 or more answers, but not all 10. (2-4 average). I don’t want to link the answers to specific cells, because I don’t want the answers to display with blank rows between answer on the sheet. I want the answers to display in 2 columns evenly distributed.
I would prefer, to not have to run a macro, if possible, but the only way I could see to do this is a very long if statement base on every combination of answers. If the only way to do this is thru a macro, I would prefer to tie it to the printing of the sheet, or I could make it part of an error checking macro I plan to do. The actual question is in the attached file