Following Code works perfectly to add sum of three textboxes on User Form into a fourth box:
But I need to "automate" it, as I need the same process across 368 sets, so tried the following two variations:
That generated the Error Message that "val" was an invalid qualified, so tried:
Which throws a Run-Time error 91 (Object Variable or With block variable not set)
Hope someone can provide the "right" syntax?
And would be even more useful if anyone can provide the Code that changes just the one textbox automatically if any of the three "trigger" columns in that row change, rather than looping through all of them if any row changes?
All solutions, suggestions and ideas welcome as ever
Ochimus
Bookmarks