Worksheet Change event and data tables

[sachinkapasi]

Hi,

I have a worksheet change event macro that is working fine so far. Here is what I am trying to achieve. I have created a sensitivity table with the column input the same cell that is the trigger for my worksheet change event. I was hoping that the data table would work and invoke the worksheet change event each time and give me the right answer but it didnt. Can someone help ?

Thanks

[romperstomper]

The data table won't actually enter each value into the input cell and trigger the Change event if that's what you mean.

[JOHN H. DAVIS]

Does this give you any ideas?

Please Login or Register  to view this content.

[sachinkapasi]

That is what I was trying.

[sachinkapasi]

I am not sure John if I follow your code. I am new to this change event macro so you might want to explain it. Thanks

[sachinkapasi]

What will Sheets("Sensitivity Table").Cells(Target.Row, Target.Column) = Target.Value do?

Does this give you any ideas?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

It is meant as a sample. If you place the code in the Change Event of the sheet you are working on then change the value in A1 it will automatically updata (or mirror) in a Sheet named "Sensitivity Table" cell A1? Not sure if that's what you are after or not, but I hope it helps.

[sachinkapasi]

I dont think that is what I am looking for. I simply have an input cell which is the trigger for my change event as well as the column input for my data table. I want the data table to work such that each value of my data table becomes the input, and triggers the change event.

It is meant as a sample. If you place the code in the Change Event of the sheet you are working on then change the value in A1 it will automatically updata (or mirror) in a Sheet named "Sensitivity Table" cell A1? Not sure if that's what you are after or not, but I hope it helps.

[JOHN H. DAVIS]

Can you provide us with a Sample with some dummy data?