Put date for specific cell according to the condition o another cell and clear cells according to condition VBA codes are not working together

[bahadir70]

I asked previously 2 codes from the experienced members and I got vba codes, thanks for the codes. they are working well separately. but I want them working together.

I have an excel sheet for my safety officers fill for daily reports. They are making mistakes while filling, so I want to make it more easy for them and for me as well.

As seen attached pictures, if R3 (condition) is "Open" if they put a date in "Q3" I want "Q3" will be cleared (only value-not format or conditional format)

and if they select "closed" at "R3" I want "Q3" will get the date on the form filled date. (but not like today() option, because today() option is updating the date when we open the form.

I did a data validation for R3 to select "Open" or "Closed"

also,

When I select the classification section "Positive Obs." in column "K" (there are 3 conditions here 1-Positive Obs., 2- Unsafe Act., 3-Unsafe Cond.) and condition "Closed" in column "R", I want the content of the related line column "M" and "Q" content clear (only contents, not formats and conditional formats).

I have seperate codes and can send upon request so the venerable member can maybe explain to me , just information, I am very new and old person (50 yrs).

 

[bahadir70]

that is perfect for positiv obs and open items working perfectly

exactly doing what I requested below.

• While Continuing to fill the form. When column “K” “positive obs.” is selected, and if as a mistake there is date at column “M” and column ”Q”, after the selection of “Closed” at column “R” at “Condition” column, I want column “M” and “Q” contents cleared.
• And similar, if there is date at column “Q” “correction date” and if the condition at column “R” is selected open, I need correction date is cleared at column “Q”.