worksheet_change event

I have a workbook with 2 worksheets. Worksheet 1 has data entry table while worksheet 2 has 2 columns for a list of names and their departments I have a worksheet change procedure in worksheet 1 that does 3 things: 1. Checks if the cell(s) changed are within a specifc range of that worksheet...

I have a worksheet (user data entry form type) in which I'm trying to catch individual changes in certain cells so that another worksheet holding the entire data table can be updated with those changes. Each of these cells require different changes so I have a Select Case catching which cell is...

We have about 200 rows of data. Each row is a day. Column A values come from other formulas on that row. Column A values range from 0 to 20 Each new entry in column A contributes "1" to the total in column B for each row until it (A) has decremented to 0. Each entry in column A should decline...

Hi I've recently been writing a few routines with help from this forum (I'm completely new to VBA). The project I'm currently working on needs two separate routines on one sheet; The first appends an "e" to any entry made into three columns. The second monitors these three columns and a...

I have a form with about 15 check boxes. A few columns over I have an important message that I want displayed when the check box is checked. I know that I can write code for each checkbox to display it's message. Just trying what I thought would be a brilliant shortcut and code saver. I am...

Hi... I have a sheet with a Worksheet_Change event. This event works great when the user manually chnages a cell in the targeted range. My problem is, if I change a cell from another routine, Worksheet_Change is activated and the cell range that I'm changing causes the code to run in...

Hi, I'm developing spreadsheet where the user will enter a path to a network drive in cell B6 of a worksheet named Input. Excel automatically creates a hyperlink after the path is entered. I'd like to use a Worksheet Change event to remove the hyperlink as soon as it's created but instead of...

I found code here (that I modified) that returns the date a cell was last modified (in another cell two rows down), but it only works if you manually change the value of the cell. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("I6:I7,J6:J7"), Target)...

Hi there, I needed to add events to the Worksheet_change event. I was helped out with the following code: Sub CreateEventProcedure() Dim VBProj As VBIDE.VBProject Dim VBComp As VBIDE.VBComponent Dim CodeMod As VBIDE.CodeModule Dim LineNum As Long Const DQUOTE = """" ' one " character Set...

Hi there. I have an Excel Worksheet that I have included a Data Validation List to. The list is populated with items for sale. What I would like, is to have the user select any item from the list, and the cost of the item should be updated accordingly. No, I read somewhere that I can use the...

Hi, How would i go about ensuring that "WorkSheet_Change" event handler only occurs when a user manually updates a cell and not when a cell change is done by another macro/subroutine ??? thanks !

Ok, I have a spreadsheet that allows someone to update cell AF,20 with a number. When they do that, the worksheet_change() function is supposed to format a range of cells based on the input value. Well, I tested the code by changing the number -- and I got an error. I fixed the problem, but...

Hello everyone, I am new to this forum and would appreciate if someone could help me out. I have a workbook with a worksheet_change event for a particular worksheet. It works fine. However, I don't want to distribute the workbook to someone, rather was hoping to create an add-in. This is what...

Hi, Hope you could help me with this. This is an "amount estimate" table. The computation centers on the Amt column. There will be a set amount in this column, e.g. 400. Then two columns on the left, to adjust values, one to increase (+) and the other to decrease (-) value in the Amt column...