so what im doing is setting a date with time in a cell. based on 4 other columns.
Columns A are the options column b are what they mean.
Column C is where time gets put
Column D thru G are data validation fields where you can pick options from column A
options fields
A B C(Time) D E F G
accept Accept time
Refuse Refuse time
Called accept Accept time
called refuse refuse time
no answer No time
time off no time
im using Private Sub Worksheet_Change(ByVal Target As Range) to get this to update.
Ex. lets say D and E = refuse and which is fine it gets time Now in C the way i want. but column F is time off it changes the time. i dont want this i want it to do nothing if B answers are blank[table="width: 500"]
c
Bookmarks