worksheet change

  1. R

    Out of Stack Space - run macro on worksheet update

    Hi, i have the following macro which calculates the hours worked, money earnt and holiday pay accrued per month in a summary table, by using the month function on the date of each shift and adding up all the values from each month!! Sub ross() Dim i As Integer Dim n As Integer...
  2. andrewb90

    Worksheet Change help

    I am trying to make certain objects hide automatically based on the number typed into a cell. I thought I was doing okay, but the second part of my code doesn't seem to be functioning. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "A12" Then...
  3. M

    Worksheet Vs. General

    Is there a way to do any macro calls from a General position instead of the Worksheet_Change Mode? For ex.: Private Sub Worksheet_Change(ByVal Target As Range) CheckArea = "A1:G19" 'The area to be monitored PUT YOUR VALUE If Application.Intersect(Target, Range(CheckArea)) Is Nothing...
  4. M

    Macro worksheet change

    I have several actions that need to be done within a worksheet change scenario. The Problem is that the whole macro runs instead of just the part that needs to work because of a cell change & it also goes into a loop or something. How do I run only the part of macro that needs to instead of ALL...
  5. L

    Worksheet_Change Event Monitoring a Range

    I have been able to successfully trigger the Worksheet_Change Event by monitoring one target cell, but how would I write the code if I want the Event to run anytime a cell in a given range is changed? This is what i tried, but I get an error that says, "Compile Error: Argument not Optional"...
  6. L

    VBA Worksheet_Change with Conditional If Statements

    Hi, I have created three macros that will format the worksheet three different ways, for printing purposes. (changes on amount of information filled in tables). Anyways, currently I have those three macros assigned to three different icons. I would like to change this so that the appropriate...
  7. C

    VBA - How to use worksheet to enter data...

    Under certain decisions, I want to access "Sheet1" from the Userform and allow the user to enter data into it. Then read the data in and continue on. I have a button on Sheet 1 which will allow the user to start up again.
  8. M

    Worksheet_Change Multiple ranges

    I am trying to modify the following code: Public Sub Worksheet_Change(ByVal Target As Range) Dim pctVal As Double If Intersect(Target, Range("I14:I44")) Is Nothing _ Or Target.Cells.Count > 1 Then Exit Sub If IsEmpty(Target) = True Then Exit Sub With Target If IsNumeric(.Value) Then Select...
  9. M

    Excel VBA Worksheet_Change

    I am trying to automatically change values by a percentage when they are entered based on criteria contained in a previous row. I have tried to do this using the following code: Public Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not...
  10. D

    Hide columns based on cells = 0

    Good Afternoon All I've found this code on the tin-ter-web and it works Private Sub Worksheet_Calculate() Application.ScreenUpdating = False Dim c As Range For Each c In Range("K8:CD8") c.EntireColumn.Hidden = (c.Value = 0) Next c Application.ScreenUpdating = True End Sub...
  11. M

    VBA update cell on worksheet change

    Sorry guys I have to raise this old chestnut I have a data feed that overwrites my column titles, so my pivot table goes awkward. All I am trying to do is ensure that Cell "C24" on worksheet "Data" always has the value "Product" in it. also various other cells that I can populate once ive see...
  12. A

    Worksheet Change Event Only If Cell Is not Blank

    I have a worksheet change event which i would like to fire only if the cell was originally populated and then changed (i.e. if it is blank and then the user populates the cell, do not fire the worksheet change event). Heres the code I have. Every time a user changes a previously populated cell...
  13. dukeofscouts

    VBA add text only if not there

    Ok I've got a worksheet change code that runs to add the text "~~SPECIAL~~" to the target's value. The issue is that as the working code runs the next time that cell is edited, the text reads: ~~SPECIAL~~ ~~SPECIAL~~ target.value I've tried to use Target.Replace to fix this, but to no avail...
  14. S

    Multiple Worksheet_Change commands on same worksheet?

    Hello all - I'm dealing with a Worksheet_Change command in Excel 2003....Q: I don't think it's possible to have Multiple Worksheet_Change commands on same worksheet? >>>>Well....I get an error message so Im guessing not... How can i combine the following commands? 'this highlights rows that...
  15. Z

    Help needed for macro+Worksheet_Change

    As being a newbie in advanced work with Excel I have a question. I have a Validation Vlookup Drown down Menu and depending on the selection the user makes there I want that certain parts of my sheet are hiding. To make it more clear I'll explain it with an example. Drop down 1 options: A...
  16. E

    Using range names with Worksheet_Change

    Hi, I need to run some code whenever a user changes the value in certain cells. Currently the code is... If Not Intersect(Target, Range("C4")) Is Nothing Then Do Something End If or sometimes... If ActiveCell.Address = "$C$4" Then Do Something End If which work fine, but I want to...
  17. W

    Using Worksheet Change when range is updated by formula not user

    Hi I have a problem in using the Worksheet Change event. My code checks the Target range named 'designStatus' and performs various checks and actions if the user changes this cell. My problem comes if the Target range does not equal 'designStatus'. In this instance, I would like the system...
  18. W

    Worksheet_Change code for multiple ranges

    Hi I have the following code in my Worksheet_Change module - each piece of code works fine, however, from time to time I am receiving an out of stack space error in Excel during execution. I do not think this code is formatted correctly for efficient use of the Worksheet_Change event (for...
  19. S

    Disable Worksheet buttons

    I need to disable the three buttons to minimise, restore and close buttons of the Worksheets for the application I am working on in Excel 07. Is there any direct method ( as available for userform) and indirect way to do this? A way to keep the window always maximised would do the trick. Thanks SKM
  20. D

    Run code when formula updates.

    I am using this code to update the cell color in F4:F3000 base on the corresponding value in each case, however because I am using a formula to update the cells containing each case this operation is not functioning only the formula is updating, not the actual value in E4:E3000. Is it possible...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top