worksheet_change

I've got some code that is driving an axis scale based on a few cells. What I would like to do is have the axis be driven by calculated cells instead. I'm thinking I need to change the code below to worksheet_calculate, but (if you haven't guessed already), I'm not sure of the changes that need...

Thanks to the help in this forum, I was able to successfully create a "worksheet_change" where a message is displayed if the user changes a value in a critical cell. Now I need to find out if there's a way to 'turn off' the worksheet_change when running another procedure. I have a procedure...

Hi I have the following code in my Worksheet_Change module - each piece of code works fine, however, from time to time I am receiving an out of stack space error in Excel during execution. I do not think this code is formatted correctly for efficient use of the Worksheet_Change event (for...

Hi, I'm forcing a time stamp into F17 based on "Pass, Fail, or Untested[P14]" value in E17 using Worksheet_Change. So far, the script works for cell F17, however, I would like it to work for the range of cells F17:F500 based on values in E17:E500. How should I modify this script to work with...

I have a workbook that I use to check dates with. Right now the Workbook will generate a calander view of the date, along with the week before and the week after. What I'd like to add is to have excel update my date entry cell ("A2") when ever I select a cell in the calander cells ("e2:k4")...

I created a worksheet with the following code to cause a macro to execute when the values in certain cells change: Private Sub Worksheet_Change(ByVal Target As Range) 'Check to see that we have enabled auto macro updating If Range("Report_Type_Auto_Run_Macros") = "ENABLED" Then...

I have a spreadsheet that runs a macro when a change happens within either of two named ranges. The original code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) 'Check to see that we have enabled auto macro updating If Range("Report_Type_Auto_Run_Macros") =...

Hi, I´m having problems calling a macro. Private Sub Worksheet_Change is located in sheet1 with the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$c$5" Then Call Macro3 End If End Sub Macro3 is located in Module2 in the same workbook and works...

Hi, I'm using the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$J$3" Then Range("K3").Select Selection.ClearContents End If End Sub Additionally: based on a selection in J3 (from a dropdown list), K3 is populated (also a dropdown list). This code...

I'm not a VBA or Excel expert, but I thought the code below was pretty simple. It basically sorts a range of cells everytime a value on the sheet changes. It worked perfectly in Excel 2003, but in Excel 2007 nothing happens. Does anyone have any idea if there is an incompatibility, or maybe...

My Worksheet_Change macro is running when I don't need it to run. When cell C7 is modified, I want it to delete the modification and display the message "You cannot modify this cell." It works properly if someone tries to modify that cell. However, it also triggers if someone selects...

Hi - I am using the worksheet_change event to change the background colour of cells (based on the MrExcel Office VBA Macros book). When the values are typed in manually eveything works fine....but I am populating the cells using an index function which links to another spread and when I change...

I have a bit of code that calls a formatting sub depending on which cell is modified. It is triggered by the Worksheet_Change event, determines which cell is modified, and either calls the formatting sub or doesn't based on the location of the modified cell. Some of the columns in the sheet...

Hi, Am using a number of checks on Worksheet_Change and Worksheet_Calculate events and, depending on the result of the change, resetting a cell value. For each of these I am using Application.EnableEvents = False Range("A1").Value = 0 Application.EnableEvents = True to avoid that the...

So what I want to do is enter yes or no into a cell and have YES answer run a macro and have NO answer run a macro. ... I am oh so close, the problem is that I can't get the code to run on the cell i enter yes or no into as once I hit enter the "ActiveCell" is now my new cell. What am i doing...