cell change

  1. SkywardPalm

    Change cell font color on Worksheet_Change if cell was not blank prior

    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...
  2. F

    Store Date in Cell When Another Cell Changed

    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...
  3. O

    Multiple Dropdown lists (sheets) default to Public Variable

    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...
  4. M

    Double click for changing cell color

    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...
  5. B

    on cell change Copy PasteValues before Enter is pressed

    <!--[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/>...
  6. S

    Detect when individual cells were changed, cells not in a range...

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

    Autorefresh pivot table on cell change

    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...
  8. K

    Change Cell information by pressing a hyperlink

    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!!!
  9. R

    VBA range change

    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
  10. E

    Excel // VBA / / Macro // Code needed to set a date in a cell in the contents of another cell changes

    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...
  11. B

    Userform to Show After Two Specific Cells Change

    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...
  12. C

    VBA to add text character when number entered

    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...
  13. Z

    VBA to colour cells if they are equal to or greater than another worksheet cell value

    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...
  14. Y

    Sum a changing Value

    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...
  15. M

    VBA assistance request - trigger event on one workbook based on another workbook opening

    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...
  16. T

    How to duplicate option explicit VBA code excel 2010

    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...
  17. G

    Trigger VBA on cell change error

    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...
  18. S

    Multiple Cell Change Events

    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...
  19. Z

    How to Increase Part of a Cell Value Using a Macro

    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...
  20. J

    Find elapsed time between two dates when change in cell value occurs

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back