1. Jerry Sullivan

    VBA anomaly when filtering table from Worksheet_Calculate

    When the user filters Table1, my objective is to have Table2 on the same sheet filtered so that both tables have the same ID items visible. Since VBA doesn't have an event that is triggered when a table is filtered, I'm using the Worksheet_Calculate event which is triggered due to the presence...
  2. L

    Set range.value as range.address

    Hi. I've got a formula that returns a cell address. I set up a worksheet_calculate event that's supposed to extract it (as a value) and give me the address of the cell next to the one originally returned by the formula among the other things. Sometimes it works but eventually it always crashes...
  3. S

    VBA message box with and IF AND statement

    I would like to have message pop up when a condition is met between 2 cells. I need something like this. Thanks Private Sub Worksheet_calculate() If Range("K23").Value > 500 And ("E23") = "KIT" Then MsgBox ("this is a test")
  4. J

    VBA Next Row Copy and Paste

    Trying to copy data to another sheet upon H1 = Suspended, any ideas what I am doing wrong here? Thanks. Private Sub Worksheet_Calculate() NextDataRow = Sheets("Data").Range("B" & Rows.Count).End(xlUp).Row + 1 If Range("H1") = "Suspended" Then Range("AG1:BC1000").Copy...
  5. M

    Streaming Data: On Cell.Value change, do stuff

    Hi, So I have this sheet that gets streaming data from another app. I want to execute some code when the value of some cells change. I tried Worksheet_Change method but it does not detect changes to the values(Im guessing it only detects manual input?) Stole this method from the forum, have no...
  6. B

    Translate this code to worksheet_calculate listener

    Hi, Im looking to translate this code into the worksheet_calculate listener as advised by members, however my lack of vba knowledge is getting the way. Is there anyway that can rewrite this code so it works in the calculate listener. Thankyou in advance!! Private Sub Worksheet_Change(ByVal...
  7. K

    Automated Macros on Formula Value Changing

    Hi, I'm new to VBA but for a project I'm working on, the calculations require a series of formulas which have to be manually carried out such as several goal seeks. So far I have been able to enable them with a series of macros with a worksheet selection change such as below. Also the macro...
  8. M

    Updating format of axis on the basis of a calculated value in a Cell

    Hi All, I'm new to this so please forgive my ignorance. I am trying to format a graph axis on the basis of the data in a cell which is calculated by formula. To do this I have created one macro (which I have tested) which I intend to reference in the worksheet_calculate() function as below...
  9. P

    Worksheet_Calculate Target Workaround?

    Hi All, I am trying to locate a cell when its value changes due to data coming into excel from an external application. It would be nice to have the column and row, but the row alone would be very useful. Worksheet_Change was tried, but I can only get it to work with changes that are typed...
  10. L

    Code works in worksheet_change but not in worksheet_calculate

    I am getting there but here is my current situation. The worksheet_change event will work with this abbreviated code. Private Sub Worksheet_Change(ByVal target As Range) '*************************************************** ' Add next group here ' [Line B1] Send Excel e-mail and output the...
  11. C

    Worksheet change vs worksheet calculate

    I've got some code that is driving an axis scale based on a few cells. What I would like to do is have the axis be driven by calculated cells instead. I'm thinking I need to change the code below to worksheet_calculate, but (if you haven't guessed already), I'm not sure of the changes that need...
  12. K

    Macro that automatically executes when cell value changes

    I am trying to have a specified macro run whenever cell B19 equals one. I tried using Worksheet_Calculate but the problem is that when the macro is run, it changes cells (other than B19) which causes the macro to start over. (One of the first actions of the macro is to enter a new row at 25)...

Some videos you may like

This Week's Hot Topics