Trying to understand Worksheet_Change event.

[Xaos]

I am trying to figure out why this code won't work.

It seems to do nothing at all.

Please Login or Register  to view this content.

I just want to understand how to build a code that updates data in a worksheet when any of the current data changes.

For example, If someone puts the letter "x" in say... Cell F4, then Cell E39's value should change to "x"


Any Help Appreciated.

[rylo]

Hi

As it stands, it seems to work. If I put a value into a cell, then it is immediately replaced with blah.

I'd change the code slightly. Whenever you turn off events, you want to make sure they are turned on again if there is an error.

rylo

Please Login or Register  to view this content.

[royUK]

Why not use formulas?

[Xaos]

Why not use formulas?

We are using formulas curently.

The problem we have run into is that we can't manually overide data that is placed into cells with formulas in them without destroying the formula.

The worksheet loads data from an external database. All of the worksheets reference this data in some way. We cannot edit the database, so if someone enters erroneous data into the database, then we cannot fix it on the spreadsheet without overiding the formula. So I am starting to look into vba as an alternative to solve our little dilemma

As it stands, it seems to work. If I put a value into a cell, then it is immediately replaced with blah.

Yes it is working for me now. I must have somehow initially turned off events while I was noobishly playing around with code. Thanks for the info

[royUK]

If the data input is incorrect you will get an error whether with code or formula, correcting the error should be no more difficult with a formula.