worksheet change event

Hello everyone, I'm back here for help again so please bear with me. I have a vba code that is triggered when there is a change in a range of cells. It works well if the changes are done cells by cells but i get an error in the case if i were to copy and paste for multiple cells in one go. I...

Hello, I'm looking for a way to take the contents of a cell and convert it to a custom hyperlink when a cell change is detected. I'm currently using a drop-down list in one column, and another to build the custom URL using that drop-down list selection. Here's what I'm using currently to only...

Hi expertise, I need help on current VBA I'm working on right now. Whenever I input in any of cell in "A:A" it will automatically register in B column. If I overwrite value in A column for 2nd time, the new input data will be captured in B column and old data move to column C As example I input...

Hi all, I would like each change in each column from YES to NO to change YES or NO respectively in column H in the corresponding row. I have this code: Private Sub Worksheet_Change(ByVal Target As Range) Dim MonitoredRange As Range Set MonitoredRange = Range("A1:C6") If Not...

Hey, I have this VBA code that works as a Vlookup with images. However, it only works when I manually enter data in the cell. When pasting values of a whole range of data (or even a single cell value), the Vba code doesn't trigger. Kindly help. I am not much experienced in VBA, and I got this...

Hello Gurus, I have two tables in two worksheets within the same workbook. I need to be able to copy the row data from Table 1 onto Table 2 once someone has entered in a completion date into the row in Table 1. (Btw, this will likely never be the last row in the table). Essentially, when one...

Hi, I had a Worksheet_Change(ByVal Target As Range) event, then I needed to add another event to the same worksheet, which I did. Then I read that it is a good practice to have an Application.EnableEvents = False and Application.EnableEvents = True statements in the code but I wasn't sure where...

I have a range of cells that if the value is changed to "R", then it should clear the contents of the certain cells to their right. The code actually works, but then I get an error. "RunTime Error '13' Type Mismatch. When I debug, it appears that the "offending" piece of the code is the third...

I want to add code to some columns in a sheet to define the number format or date format using the following codes ThisWorkbook.Sheets("Report").Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "mm-dd-yyyy" ' date format ThisWorkbook.Sheets("Report").Range("J2:J" &...

I have a worksheet change event that will add columns to worksheets based on a value. I am trying to get it to add columns to certain sheets based on one value and add a different amount of columns to different worksheets based on a value from a different cell. The code is: Private Sub...

I am working on a Userform that allows users to sign into projects using their login and password credential. However I'm running into a situation where sometimes my worksheet_change events work and other times they don't and it's allowing for the same username to be entered when creating their...

Hi all, Using Excel 2016. I created a connection only in Power Query to table on my worksheet with a single row to be used as a file parameter. The parameter can be 1 of 2 values based on selection by user and that part is working as expected. I added a bit of code to the Worksheet Change...

I know very little about VBA but I created a simple If/ElseIf code that is apparently too large because when I make the necessary change on the spreadsheet that runs the code it gives me a "Compile error: Procedure too large" message. Essentially, the user has a drop down list in each cell O31...

Hi, i have added the following code to my worksheet_change event and getting the error while running this code on Excel 2007 but working well on Excel 2013. Can any body help to solve the issue as i am trying to calculate the things for both column value change. The error message is as: "No...

I have the below code that isn't doing what I'd like and I think I know what the issue is but I can't figure out the solution. Basically there are two cells "ShBal" and "BanBal" with numbers and if they match then the Match subroutine runs. BanBal is manually entered by the user and is constant...

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...

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...

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...

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...

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)...