cell change

I have been trying to solve this for if a quantity cell is changed, but can't figure how to avoid if the cell was blank first. I only want to adjust the font color if the cell had a value in it prior to being changed. Private Sub Worksheet_Change(ByVal Target As Range) Dim QtyCell As Range...

Boy am I glad I found this forum. I'm hoping some of you can help a novice out... I have a file that tracks supplies and therefore has a sheet for each of our office locations (a total of 30 or so tabs/sheets). Every Monday the Admin for each office needs to review their sheet and adjust the...

Hello, I have a workbook with 5 sheets. Each sheet (in Cell P1) has the same data validation dropdown list (Source=compname). compname is a named range that includes (Alpha, Bravo, Charlie, Delta, Echo) I have also set a Public variable compset as String. My intention is to get the...

I have this VBA (see below) to change the cell color on a double click. I need to make this so it will change a row of cells with the double click. Any ideas? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True Select Case Target.Interior.ColorIndex...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hello, I have a snippet of code which detects when a cell in a range is changed. I'd like to use it to detect when several cells not in a continuous range on the same sheet are changed...one option would be to define a bunch of ranges and do-while through them all, I guess. here's my starting...

I have a pivot table (Pivottable2) which I want to refresh any time the value in cell B3 is changed. I have used the code below but appears that I am doing something wrong. The name of the macro to refresh the pivot table is "refresht" Any help greatly appreciated Private Sub...

Hi! I have a hyperlink in an excel sheet that send me to another sheet. I would like to know if there is way to change the information in a specific cell in the second sheet by pressing the hyperlink in the first one. Thanks!!!

Hi everyone. I want to have a macro that when any cell changes from column V to column AH (starting in row 3), then on column AI an "x" must appear on the row where the changed occurred. Can someone walk me through it? Thanks in advance, Rui

Hello All: I have a spreadsheet and I need some VBA assistance. I think this is easy but we shall see. Cells E2 through E1000 may contain either OP or GS. On initial data entry, the contents of the range will be set to either OP or GS (data entry will start at E2 and proceed to E3, E4, Etc...

Hello - I am attempting to have a userform show after two specific cells are changed and to not show again when any other part of the workbook incurs a change. Below are the cell references to cause the userform to show: Cell / Range Name 1: C4 / PROVFYB Cell / Range Name 2: J4 / PROVFYE...

Hi all, So this is a strange one and must be solved by using VBA. Any help is much appreciated. Plain and simple, when a numerical character is entered into a cell I want the result to add "Group " before the number. So if someone enters 100, the result is "Group 100". If the number has been...

Hi All, Please could you help me. I am trying to loop through the rows in my worksheet and then if the cells in a column match a value in another worksheets cell then I need it to change to colour of the cell. My Main table has about 50 rows and the headers start in row 2. There are 23 Columns...

Hi, I am currently working on a simulation in excel using and add-on called Crystal ball. What this basically does is change cells depending on a given assumption that is user defined. What i am looking to do is sum the value of the cell whose value will fluctuate when the simulation runs. Eg...

Hello, I am trying to come up with a macro that will make a change to one workbook based on another workbook opening. basically something to the extent of this: If workbook 'Master' opens, then change the color of cell A1 on 'sheet1' in workbook 'Tables'. The scope of this project is as...

I have used the information from another post but this is a new type of enquiry. Originally Posted by Ruddles Create the "timestamp info" worksheet by hand, make the top row bold and freeze it. Paste the following code into the code module for your main worksheet - the one where B321...

Hi all, I'm using the macro below to detect cell changes in a column. If a change is detected, the address of the change is used to build an array of related rows to which I want to apply another macro. This is working beautifully when I either enter a value in a cell or clear the contents of a...

Hello, I have a sheet where users enter inputs, and I want the sheet to clear all inputs when they change the account name. The code for this is below, and was successfully implemented: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C4")) Is Nothing Then...

Hello, I'm am trying to increase part of the value of a cell using a macro. The formula is very complicated, so it takes a long time to edit manually. Here is what I would like it to do: Input cell value...

Working with process temp controller, the data is formatted in a series as the following; Start Hi T Lo T T SD ET 01/21/13 105.23 105.98 105.66 01/27/13 105.77 105.33 105.55 6 D .11...