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

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

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")

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

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

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

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

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

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

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

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

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