worksheet change

Hello I am new in Excel and I would thank a lot if someone can help me. I wrote this code with linked dropdown lists in cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$S$4" Then Range("$T$4").Value = Empty End If If Target.Address = "$S$5" Then...

Hello, I'm really new to the VBA world and I'm currently trying to create a form which can be filled out. I got pretty far already but now I'm stuck. the problem is that I don't know how to combine two makro's under one Worksheet_Change. So i do have this existing makro which is working...

I am trying to display a msgbox if a user selects certain options in a dropdown box. Here's the scenario. This is for a scheduling assistant I am building. Daily schedules have several cells with a dropdown lists that refer to the entire staff. I know the staff's availability, so I have...

I have been trying to solve this for if a quantity cell is changed, but can't figure how to avoid if the cell was blank first. I only want to adjust the font color if the cell had a value in it prior to being changed. Private Sub Worksheet_Change(ByVal Target As Range) Dim QtyCell As Range...

I appreciate you all in advance. Now I'm struggle to break down VBA codes. My demands are three. 1. Declare Public Variable 2.Use it in worksheet_change 3.Call certain procedure from worksheet_change Thus I have three codes below, Code1 in worksheet module("Sheet1") And Code2, 3 in standard...

Hi expertise, I already enable worksheet change that will record every single data after click in specific cell. But, I have one problem onto count (preferably in range G:G) the cell within same row in multiple cell. Can anyone help me on this? Thank you. Option Explicit Private Sub...

Two parts to this query: 1) I've written the following code to address each row within range (F15:F44), aka table "WellList[ERP Group ID Number]". It works, but it's rather ridiculous and repetitive. I'm looking for something more concise/elegant which will still allow the user to drag the...

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

Hello everybody :), I am fairly new to Excel VBA and i struggle to figure out how to pass a variable from the worksheet_change to a module where the variable is picked up and is printed. I hope you guys can help me. Private Sub Worksheet_Change(ByVal Target As Range) If...

Hello all, I have a worksheet change code that inputs the date when a cell in my range is edited and clears it when the range is cleared, however, I am looking to change it where only the value of "Y" inputs the date, and anything else would clear it. I'm sure I'm pretty close with some of my...

Hello all, I have a worksheet change code that will input the date, time, and users name into the log that they are working on, My challenge is that I am trying to automatically unhide the next row after input has been entered into column b of the last row filled in. I've found some options...

Hello, apologies for any errors this is my first post and I am relatively new to VBA. I work in a lab and we use a spreadsheet for recording some tests that need to be sent away. I need a msgbox to appear when a specific test is recorded "HER2" to remind the user to check if another test is...

I know that the worksheet_change event is fired when a cell is deleted. Can I store the address of that cell that was just deleted to use it to then delete the same cell reference in other sheets? For example if I delete A3 on Sheet1, can I then select A3 on Sheet 2 and Sheet 3 and delete it on...

Hello, I have many shapes (78) that I need to change the size of when a cell value is changed. The following code works to change one shape but I'm struggling to get it to work with more than one shape. Private Sub Worksheet_Change(ByVal Target As Range) Dim myRect As Rectangle If...

Hi all, I am currently stuck on finding a way to input all new changes made to a specific row of cells into a string so that I can parse the final string into another function that drafts out an Outlook message. As there will be continuous updates made to the row, I want to be able to "write"...

Hi, below I have VBA for worksheet change. But I want it only to run on 1 sheet, not across all sheets. What do I need to change to make it run for a specific sheet name. Private Sub Worksheet_Calculate() Static oldval If Range("F3").Value <> oldval Then oldval = Range("F3").Value '...

I've been searching all over for a couple of hours and it seems what I am looking for is either too simple to have been requested. I see far more complex requests but I still can't figure out how to do it. I have an excel table where users will enter data in columns A3 -> D3. Column E is hidden...

Hi 1) Can anyone guide me as where I am writing my code wrong? I need my worksheet to do two separate things for two sets of ranges via worksheet_Change event. the top part works, but the latter part doesn't run at all, ie. the part where I need Excel to locate & go to the adjacent cell by...

First of all, good morning and thanks to all of you who come on here and help us out and never asking much in return. You've inspired me to go to other forums where I actually do something about the subject and help out. :) I seem to have a sick dog now that is wanting attention so I've broken...

Hi guys, I'm new to VBA macros and cannot figure out a way to add a loop to my macro. I have data output from an experiment and want to do the following: Copy/paste data from sheet "Data" to sheet "Summary" (see below code). Loop with an offset of 130 rows. The paste function should select...