worksheet change event

  1. J

    Worksheet change offset BUT ignore if offset value exists

    I have a worksheet change macro that both updates an offset cell value with a date & a selection of cells with corresponding offset dates, however I am trying to update it so that it only inputs date if the offset cell is blank. Here is the code that works: Private Sub Worksheet_Change(ByVal...
  2. S

    Capture Multiple Cell change

    I have code that watches three different columns for changes. It works great when only one cell changes at a time. But if I copy and paste multiple cells of data in to the columns at a single time, it doesn't work. I am pretty sure that I know why, but I can't figure out how to change it to...
  3. L

    Called macro doesn't do anything

    Hi. I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as...
  4. Tim_Excel_

    Workbook_SheetChange event loses reference to Workbook

    Hi forum, I have a Workbook_SheetChange event for another workbook (other than the workbook that holds the code). At the end of a lengthy Sub, I call for the Sub that defines the Workbook's name that the event needs to work for: Sub step1() '''''code'''' NameGrabber.DefineWorkbookName End...
  5. S

    Worksheet_Change - Multiple Changes - Code not working ?????

    I have a worksheet with a Worksheet_Change sub in it. I have two sets of code in it. Each set, individually, works as planned (tested). But when together, for some reason only the first set is catching correctly. Here is the code: Private Sub Worksheet_Change(ByVal Target As Excel.Range)...
  6. E

    Two Worksheet_SelectionChange on one worksheet

    Hi everyone, I have a sheet with two blocks of data. On both blocks, I want to hide a different number of rows, using the following code. The thing is that VBA says I can't have two of the same. Is there a way to have one (or more) macro(s) have multiple Worksheet_SelectionChange(ByVal Target...
  7. M

    How the get the column or row number of a changed cell on Worksheet_Change condition?

    Dear Gents, Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("B2:B5")) Is Nothing Then Cancel = True ActCol = Activecell.Column 'other macro According to above codes, If the user change the value of B2 to B5 and press "tab" on...
  8. H

    Excel worksheet change or display list of data based on given cell text

    Hello Team, I am planning to build one dashboard using work sheet change but not sure how to work with this option. My objective is to display list of fields based one cell value. For example in A2 cell if you select "Fruit" then below automatically list of fruits should reflect and it should...
  9. P

    Log file where each line gets a date stamp when populated and where date is then stored as value

    I have a simple log file with a couple of columns to log events. One row for each event. Every cell in a row is manually entered and there are no macro's or formula's yet. To prevent mistakes I now want to make a modification in column A... the date column. As soon as one of the other cells in...
  10. C

    Combining Multiple Worksheet_Change Subs VBA

    I've been trying to combine to separate change events in my VBA code. The first allows users to insert hyperlinks into specific columns and the second enables multi-select drop-downs in other cells. The problem is I can't get them to work together. One always over rides the other. I've read...
  11. D

    Changing values of cells to uppercase in a private sub

    Hi all, I have this code here that simply turns the cells to uppercase. [CODE][ Sub Turn_Uppercase() For Each x In Range("C3:H200") x.Value = UCase(x.value) Next End Sub /CODE] Does anyone know how would I adapt this code so that I can run in a sheet tab (Private sub...
  12. D

    Looping a worksheet change event

    Hello all Im ok at writing some simple code in vba but when it comes to looping the code I always screw it up! I have a code that is working and doing what I want it to do, except I have to re write this for 10000 cells! which is extremely time consuming, as you will see I have shown the exact...
  13. S

    Message Box VBA

    I am trying to get a message box to fire automatically based on a cell value. Here is the setup: I have a "configurator" tab (Sheet 2) that has an ActiveX drop down box with a list of names that corresponds to a table of names/job titles on a logic tab (Sheet 3). When you select your name on...
  14. D

    Co-Authoring Issues - Sharepoint & Macros

    Good evening all, I am looking into rolling out a sharepoint adoption at our company, using the co-authoring capabilities of Excel 2016 with OneDrive/Sharepoint to enable sharing of macro-enabled workbooks with userforms etc (at last we can do this!) I am however hitting a snag with...
  15. M

    Combining multiple Worksheet Change Events

    Hi all, I have two worksheet changes that I am having trouble to combine so that the changes work at the same time. The two changes do affect the same cells, but one hides the whole row and one stops specific cells from being deleted. Here are the two codes: Private Sub Worksheet_Change(ByVal...
  16. F

    VBA Worksheet change: nested If to run sub if transposed ranges don't match.

    I have a range of column headers that is transposed from a list in column B. When a value from column B changes, I have a macro that will copy those values and transpose them into row 8, starting with R8. I want to prevent the user from changing the column headers. I want the column and the...
  17. George J

    Passing variable due to worksheet_change

    Never been too good at passing variables, but can usually keep it simple enough to get by. Not this time however. I have a macro that works okay and part of this calls another macro. The second macro passes 2 public variables and this seems to work okay. As part of the second macro however I...
  18. L

    Issue with "worksheet_change" event

    Hello all, I have produced a piece of code for the "worksheet_change" event but run into a problem. What the code does: Whenever one or more of the KeyCells is updated the code should run and update the color of its linked shape. What is does now: If only one KeyCell changes its value the...
  19. X

    Two Subroutines, one Worksheet Change event

    Is it possible for two different subroutines to inhabit the same Worksheet Change Event? There are two separate results that I would like to achieve, first is making a second worksheet visible based on which process is selected in cell "A1". Secondly, I would like to establish a tab order for...
  20. J

    Worksheet change event required for linking sheets

    Worksheet change event code required for linking between 2 sheets one is Raw Data other one is SH I want that if there will be any value in AH column of Raw data sheet then B Column value of Raw data sheet will be linked to C column of SH sheet staring from Row 4 onward in SH sheet.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top