Only run macro on manually edited fields

[David_L]

I am attempting to set up an inventory control spreadsheet with several levels of sub-assemblies between the base components and finished products. I have figured out most of what I need so far, but was wondering if there is any way to check if a field was edited manually, as it seems that "content changed" fires whenever anything changes and I would rather not have things propagate further than I plan.

[FJCC]

You can use Data Validity to trigger a macro. For each cell, choose the menu Data -> Validity. Set the criteria to be a Text Length less than or equal to zero. On the Error Alert tab, set the Action to Macro and use the Browse button to choose the macro. With those settings, entering anything in the cell will trigger the macro.

[David_L]

That looks like it will work, thanks.

Any idea why ActiveCell.Copy is grabbing the old value rather than the edited one?

Edit: Looks like the validator, and thus the macro, runs before the cell is updated. I was honestly hoping there would be something I could simply check with an if statement.

[FJCC]

Let's take a step back. What are you trying to achieve with the macro? Maybe there is another, simpler approach.

[David_L]

I've changed a few things since my initial question, and in a way it almost no longer applies. I am now planning, again, to use the Sheet event > content changed trigger to watch specific columns and run the appropriate macros from there.

I have attached an example document, the process I would be using begins on the Assemblies page in column D.

Edit: As I seem to be unable to attach files at the moment here is a link to it. http://filehost.loretracker.net/Invento ... xample.ods

Edit: File attached, since filehost.loretracker.net link may break -- MrProgrammer, forum moderator

Inventory_controll_example.ods

(25.15 KiB) Downloaded 56 times

[Bidouille]

The structure of your document suggests that a database would be more efficient.
So use Base instead of Calc.