If Line Ends In Assigned Value Then Change Item In COMMENT.
May 22, 2006
I have an Excel file with text records, 1000s of lines long Trancriptions of Customer sales reps and Customers, or Distributors. All data is in Collum A.
Each Record has 7-10 Entries
______________________
BILLNUM : 060501
ORIG : 12345678909090
REP : 45672222222222
AREA : LK787878000000
SD : 060401
ED : 062025
COMMENT : CUSOMTER CONVERVERSATION WITH REP
C:HELLO
R:HELLO
C:MAY I HELP YOU
R:BALANCE PLEASE
etc......................
View 3 Replies
ADVERTISEMENT
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
Aug 20, 2013
How do I add a "comment" to an item of a drop-down list? I've got several items and every item has its own comment. I dont know how to do this.
View 1 Replies
View Related
Mar 20, 2007
I've created a custom toolbar and populated it with a custom button. I have created a macro and it resides in ThisWorkbook. The macro is assigned to the custom button and the toolbar attached to the workbook. So far, so good. If I copy the workbook and rename it, when I click the button to run the macro it launches the original workbook and runs the macro. The macro effects changes on the renamed workbook copy. The macro name found in the assign macro dialogue starts with the original workbook name. The same effect if the macro resides in a module or sheet. Any known way to have the macro name change along with the renaming of the workbook such taht it refers to the currently opened workbook macros? Regards.
View 5 Replies
View Related
Jan 29, 2014
Adding ' 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 Related
Mar 30, 2007
Looking to perform a search on a folder of all files containing a string; example: Item#. Would like the vb application to return the following for each entry found:
FileName, DateLastModified, [Entire Line] the character string was found on.
Brass Solution: Search Excel files only
Silver Solution: Search Excel and Word files
Gold Solution: Search Excel, Word, and .PDF files
View 2 Replies
View Related
Nov 17, 2012
Our small family business has a mailing campaign that we track with excel. However, we're very concerned about users opening the macro-filled master spreadsheet. Instead, we'd like a macro to do everything for them.
When a letter comes back in the mail with a bad address, the user types the Street number and street name such as "1234 Main St" into $A2 of c:dropbox eturned.xlsm, presses the macro button, and it should do the following:
Opens and Searches "Sheet1", "column S", in the file c:dropboxmaster1.xlsm, and finds the LAST instance of the address typed.Selects that entire rowCopies the entire row.Pastes the contents into the row of the active cell in the destination spreadsheet, overwriting what was there before. Such as $2:$2 if the address was typed in $A2.In the master1.xlsm spreadsheet, sets the entire copied row color to "gray".closes master1.xlsm and saves changes.
The end result is that the user now has an identical row of information in their spreadsheet, and the master spreadsheet's row is colored gray indicating it has been completed.
Other notes:I'm open to more efficient steps than this if you have them.There are approx 5,000 records to search through in master1.xlsx at any given time.
View 5 Replies
View Related
Jan 5, 2014
I have a list of 20 cities in K1:20 and they can be selected from a drop down menu in column A2:A22. I want then to randomly pick 6 out of 20 and these 6 cities must to appear in a line A1, B1, C1, D1, F1, and G1
On cell A1 I have used the
IF ( A2=K1,K1, IF(A3=K1,K1...................A22=K1,K1,IF(A2=K2,K2......A22=K3,K3)
It seem to be an endless formula is there another way to make it easy ???
View 10 Replies
View Related
Jun 10, 2014
I have a little trouble with my macros. I wrote several different macros, each for a special purpose. Then I created some Buttons, which would make it easy for others to work with them.
But I have now experienced several times, that my buttons don't keep their assigned macro.
View 5 Replies
View Related
Feb 6, 2014
I manage an monthly inventory spreadsheet with over 100 various items in the master list. However in any single month there may be only 5 or 10 active items that need to be reported on. How do I develop a macro that will check the "items on hand" column and delete the entire row if the quantity is "0". My report is limited to showing only items on hand and not the entire list of items.
View 1 Replies
View Related
May 21, 2010
I have a chart sheet with a line graph that contains two series: I want to change their thickness, but I am not able to format it with VBA.
View 6 Replies
View Related
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
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
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
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
Target.ClearComments
[Code] .......
View 1 Replies
View Related
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
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
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
Sep 26, 2008
Is there a way to comment code without having to introduce ' before each line? Very much like in C language, we use /* to open comment lines and */ to close comment lines. I know we can use _ [underscore] but I find it not very pratical. Both solutions for comenting in VBA aren't very pratical, specially when copying and pasting coments from a text editor for example.
View 3 Replies
View Related
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
May 7, 2013
I have a number of comment (all column D) that have lots of data in each one.
The data will appear like this (each new entry (new entry denoted by a date))
01-May 12:58:05 Liam
02-May 16:18:27 Josh
07-May 11:51:26 Bob
02-May 01:13:34 Terry
What i want to know is, can i change the colour of the text in the comment, if its todays date. So in this case 07-May 11:51:26 Bob goes red (its the 7th here for me).
View 3 Replies
View Related
Feb 3, 2008
It seems that you can change position when you editing comment and its remembered, but when its showing its alway's on default position.
Is there way to change position of displayed (when you mouse over cell and coment pops up) comment position?
View 3 Replies
View Related
Jan 19, 2014
I am trying to add up the same item until it changes. I have attached the file with the desired outcome in the 2nd column.
View 1 Replies
View Related
Oct 16, 2007
I am trying to number rows based on criteria. when the value changes add a 1. This is what I need to have happen
Apple - 1
Apple - 1
Apple - 1
Orange - 2
Orange - 2
Plum - 3
Plum - 3
I can get an if statement to number everything 1.
View 8 Replies
View Related
Oct 22, 2013
I have goal table on table A and i want it data fill to tabel B with constant sum. maybe like sudoku in sum right and sum down.
View 1 Replies
View Related
May 14, 2009
I am trying to change the caption of a toolbar item but for some reason it does not work.
Application.CommandBars("Format").Controls("Item...").Caption = "I&tem..."
However,
Application.CommandBars("Format").Controls("Item...").Delete
for example works just fine
View 9 Replies
View Related
Nov 22, 2006
I'm trying to create code where a user can input criteria into a cell then run a macro. The macro would then use that criteria to filter the pivot table. I have attached an example. The first portion, using date to filter the current page - pivot item is working. I need to creating the code to use the "supplier" to filter the pivot items on the row. As a note, both the Date and Supplier cells are named references.
View 2 Replies
View Related
Jul 2, 2007
Suppose I have a department List, and I made a list from that column (Department List), and I enter more staff and selected a department for them during registering, now one of the Department List Item change, How is it possible to change all the entry which has that department?
For more info see the attachment.
View 7 Replies
View Related
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
Aug 30, 2013
I have a Multi-Select Active-X Control Listbox and an associated Button. I am trying to create a dynamic Select ALL, Clear All Button. Clear All Function Works, but Select All triggers the Change Event for the Listbox.
figuring out a way to either
1. Disable the Change event until the "Select all" loop is completed or
2. Find a way to write the action for the Button directly, such that the click event is programmed as part of the Change event, and everything is done in one.
Cannot Attach file due to file size, code below:
Option Explicit
Dim i As Long
Dim j As Long
[Code].....
View 3 Replies
View Related
