worksheet change

  1. 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"...
  2. 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 '...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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?
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. M

    Combining multiple Worksheet Change Events

    Hi all, I have two worksheet changes that I am having trouble to combine so that the changes work at the same time. The two changes do affect the same cells, but one hides the whole row and one stops specific cells from being deleted. Here are the two codes: Private Sub Worksheet_Change(ByVal...
  17. T

    worksheet change macros inconsistant

    I have the following macros set up in one worksheet "code-behind" page to call other macros when specific cells are changed: --------------------------------------------------- Private Sub worksheet_change(ByVal Target As Range) If Not Intersect(Target, Me.Range("B9")) Is Nothing Then Call...
  18. andrewb90

    Worksheet change making object appear

    Hello all, I'm not sure if this is possible to do, but I figured I'd ask around and maybe someone smarter than I will have a creative solution. I have a worksheet change event that highlights the current row that is selected. See below: Option ExplicitConst MyAreas =...
  19. andrewb90

    Customize right click on page tabs

    Hello all, I have been able to customize the right click menu on various cells in my workbook, but I was wondering if it were possible to customize the right click menu that appears when you click on any page tab. Is this possible? Any help would be greatly appreciated. I'll attach the code...
  20. D

    Application.enableevent code within a worksheet change sub

    Hi there I have a simple code that hides rows when either W or S is selected in a cell ("H19"). I want the code to disable after a selection is made so the application.goto does not activate every time i populate a cell, however code should be activated again when the cell ("H19") contents is...

Some videos you may like

This Week's Hot Topics

Top