cell change

  1. 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...
  2. 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/>...
  3. 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...
  4. 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...
  5. 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!!!
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. A

    automatically change the data entered into a cell to a specific format

    I saw this done once, however the VBA code is locked and I cannot look at it. I have been dying to know how this was done. I am fairly certain it is VBA execute on enter, however I do not know for sure. Here is what happens: Enter value 6p, or 0600p or 1800 into cell, press enter...
  19. S

    Re: Run Macro on Cell Change via DDE change event

    Re: Run Macro on Cell Change via DDE change event I want to run a macro everytime a specific cell changes say A1, the cell changes in real-time from a source using DDE. I have had this working once before but I lost my notes and forget how to complete this.
  20. H

    is there such an event as cell change

    I need to do data manipulation based on a particular cell being changed, I can try to work it on sheet change , but cell change would be a lot easier, if it is possible , please advise correct syntax also best location to put the code

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top