worksheet change

  1. A

    Worksheet change issue

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

    Adding Auto unhide rows to my worksheet change code

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

    Display VBA msgbox when cell contains text

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

    How do I store the address of a deleted cell during Worksheet_Change Event?

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

    Multiple Worksheet Changes in One Worksheet

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

    VBA code to continuously append strings to a default text in Worksheet Change

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

    Worksheet Change VBA for just 1 sheet

    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 '...
  8. L

    VBA worksheet change copy values derived by formula to adjacent column in same worksheet in Excel table

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

    Worksheet Change code stuck

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

    VBA - Maybe Looping - Activate Multiple Sheets?

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

    VBA for copy/paste to different sheet with loop

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

    How to skip Worksheet_Change?

    Can I skip/disable a sub code before run my marco then recover it like as following: Private Sub progress() Skip run/disable Sub Worksheet_Change(ByVal Target As Range) My Marco Recover/enable Sub Worksheet_Change(ByVal Target As Range) End Sub
  13. B

    Triggering a worksheet_change with a command button?

    Can worksheet_change macros only be set up to automatically run in response to data changes? If there anyway to set it to respond to a command button?
  14. A

    VBA: If cell contains [criteria] enter data

    First off, I just started to really learn vba, so I'm clueless to some of this stuff but I do know how to research and learn. Now, I have a worksheet that I to automatically input data into cells when specific columns are changed. I've been working and searching for hours and I have had no...
  15. J

    VBA comparison operator not working

    Hey all, A little background on my vba project: When the date in a cell is a past date, the cell style changes to "Bad". I am trying to code this logic: If you change a past date to today's or a future date, then change a cell in another column, but same row, to the style "Neutral". For some...
  16. J

    Use a List of Existing worksheet names and update them based on new list

    I have a list of existing worksheet names in A1:A50 (although the worksheets themselves are NOT in that order) and a list of new names I want to update each sheet to in B1:B50. I would like to run a macro that looks for the worksheet name in A1, finds it in the workbook and then renames it to B1...
  17. C

    Excel Manufacturing inventory

    Recently got promoted at my job to start and manage inventory. We have a set up excel sheet but currently have to manually update inventory when a product leaves. To keep it short for example product one uses 5 screws, 2 nuts, and one hinge. How would I make it so that if I enter that we sold 5...
  18. andrewb90

    worksheet change event for multiple cells

    Hello all, I have this code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, [H16]) Is Nothing Then If [H16] < -9.99 Then [I1].EntireColumn.Hidden = False Else: [I1].EntireColumn.Hidden = True End If End If End Sub It works perfectly, but I...
  19. andrewb90

    Worksheet change event when changing cell data

    Hello all, I am trying to do a worksheet change code, but can't quite get it right. Private Sub Worksheet_Change(ByVal Target As Range) If H16 < -10 Then Columns("I:I").Hidden = False End If End Sub What I am trying to do is, when the value of H16 is changed, and it is less...
  20. S

    Two Cell Change Worksheet Macro - Private Sub Worksheet_Change(ByVal Target As Range)

    Hi, Need help I am new pretty new to VBA, created a worksheet it is working for 1 condition but I tried a lot but unable to make it work for the second condition in the same worksheet. Background: The first code pasted below calls the I need to below code to call a macro when the condition1...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back