worksheet_change

Hi, I have a dynamic area under B14:H14, which I only want to add rows to via macro input and not limit via cell protection. Is there a way to use Worksheet_Change to detect if a user enters a value in a defined area and prevent cell value edit? Tried to search for answer, but must typing...

My program has both a Worksheet_Change event and a Worksheet_SelectionChange event. For some reason, when it runs to the end of the Worksheet_Change event, it jumps to the Worksheet_SelectionChange event. Has anyone experienced this before?

Hi, I want to run a filter when one of twenty named cells are changed. Problem is I can only add two cells to the 'set cells', I need to add twenty. Also the filter runs on 800 cells, is there anyway to speed it up a little? Thanks in advance. ( I'm not an expert at VBA :) ) Private...

I want to be able to have a workbook do a function when opened. So I want to have a targeted column in a sheet, if a date is 90 days prior to the current date, it will automatically delete the section associated with that date. Example - if today is 4/23/19 and a previous input in a sheet is...

MAJOR AMATURE ALERT! I'm trying to code a module to record the time of changes made to a workbook (several worksheets) to another worksheet. I can get the code to record the time of the change for a range with multiple columns to the next cell over (xOffsetColumn = 1). I am trying to send that...

Hi, I am using VBA to automate values in a specific column for a tracking sheet. It works great but as always is the case I am wanting more. Can anybody help me reorganise these 2 pieces of code so that they work simultaneously in the same worksheet change? Here is the code: Private Sub...

In the code below, recording TO respective sheets works well... recording FROM respective sheets changes the value in B3 thus execute the recording TO respective sheets again... the former is essential, how to stop the latter ? Private Sub Worksheet_Change(ByVal Target As Range) Dim myWS As...

hello guys, I have a Worksheet_change code that is working perfectly well (see below). I would like to add another code, using the same functionality i.e. (Worksheet_change) so that all entries in column HA are automatically Uppercase. How can I add a second code, right after the one below so...

Hello, I have a sheet that user can update. Columns A, C-G and I-J are text Columns B and H are date format. I force the format to consolas (to see difference between O and 0), set the date cells to yyyy-mm-dd, do some centering and indenting. BUT: I do this inefficiently on all cells from row...

I have a timestamp I've previously talked to people about. It's a worksheet_change item and I either need to make it into a macro that runs automatically (so when I input data into "R5" it puts a permanent, non-changing/updating timestamp "dd-mmm-yy" in "F4" The fun part about this- it needs...

Hi, Is there any way to use worksheet_change event only when user input some value? I do not want to execute event when value will be added by macro. I know that can use Application.EnebleEvents but I really do not like it couse of possibility of demage all macros when some error occurring...

Okay, so correct me if I'm wrong, but the purpose of the Worksheet_Change function is to run your code and update each time something is changed in the actual Excel sheet, right? I am having trouble using the Worksheet_Change method in my VBA program. Photos here of my code and then of my...

Hello, I am looking to modify the below code in a way that when the user selects "Yes" in the drop down in cell A1, macro should just Exit sub. And when user selects "No" in the drop down the code should trigger "MyMacro". Private Sub Worksheet_Change (ByVal Target As Range) If Intersect...

Hi all, I have a Worksheet_Change function and a Workbook_BeforeSave function in my master file. When the user selects a specific value in the target field of the worksheet, it will cause the workbook to save. The BeforeSave function kicks in and attempts to send updates to/get updates from a...

Hi all, How do i use the worksheet_change event to do the following? My named range is "Timelog". If first cell of last row in named range "Timelog" is blank, then do nothing, if not blank, then add row to bottom of named range "Timelog". Thanks for your help!

Very simple question. Is there any way to only cause an event to happen ONLY when the value in a cell actually changes? Thanks

I have a user form set up to add a new part # to the worksheet, gather some data then create a new row adding that data once you click 'save' and that works fine but once the new row is added I want the sheet to automatically sort Ascending on column C...I've tried many different things and...

Hello, I am trying to have a Worksheet_Change that will run a VBA code. Right now I have the first part done. What this code does is that it works with a Drop-down list in Cell V6 and when someone selects this drop-down list it will run a code called Do_it_1 and also change a commandbutton...

Hi guys, I've written some code to protect certain ranges from unnoticed editing. unfortunately its not working yet. Ranged H9 - X(COUNTED nr) must activate the macro. Sub worksheet_change(ByVal Target As Range) Dim rng As Range Dim R As Long Dim txt As String 'count used cells R =...

Hi, Thank you for this site! I've learned so much just reviewing the posts and challenging myself to write better and more increasingly more complex code. Here's what I have: -All Cells are Unlocked and Sheet is Protected with no password -Cells I6:L14 MERGED across each row (I6:L6, I7:L7...