Automate Down Fill VBA

I know there has been subjects written about this but I'm still having a few issues. I am looking for a code that will down fill a range of cells in a row if a user enters values in the adjacent five cells. I need this to be automated so I don't have to run the macro every time.

An example is that if I enter values into cells B5:F5, I want macro to automatically down fill formulas into cells G5:J5. Only when all 5 cells have a value can the macro run and if I accidentally delete a cell from B:F that had previously been filled, I don't want the macro to break and yell at me.

Is this possible?

I have some knowledge with VBA but definitely probably run through too many hoops to get what needs to be done. My guess is I'll be using a combination of private and public macro.

Hi Ford - Really appreciate the thought. The reason I don't want to use formulas is I want the cells blank prior to you filling in the 5 user defined cells. I may use words/dates/numbers and dont want anything to muddling up the sheet. All in all, what I'm looking for is if someone was filling out a form with 5 variables, they wouldn't need to drag down formulas above and there wouldn't be anything in the formula cells until you've entered those five things. Lastly, once entered it be great if the macro would "recognize" the conditions have been filled and then would down fill automatically.

Please see the attached. I have given a very simple down example. If you run the macro it'll populate cell G5 and H5 but I am hoping to automate this to populate once you've typed in the word "No" in F5.

I hope this clarifies and thanks again for your help.

I definitely get it, was just looking for something a little cleaner. But I may turn that way if I can't figure it out! Cheers for the help.