The Doctor
Member
I've got a sheet where we ask field reps to estimate start and stop dates for multiple job sites. this means I have 2 dtpickers for each row on the sheet, and I would like to hide them until the site name/number is filled in. Essentially if the name cell is blank the date cannot be seen. I'm sure this will require a VBA, and I'm too much of a rookie on VBA to come up with the code myself. I've got a dummy sample, but I'm not sure how to attach it.
Essentially I have dtpicker3 through dtpicker16
cells A16 through A22 are the blank name cells.
essentially I'm looking for something to the effect of if A16="",DTPicker3 and DTPicker4 are hidden.
Essentially I have dtpicker3 through dtpicker16
cells A16 through A22 are the blank name cells.
essentially I'm looking for something to the effect of if A16="",DTPicker3 and DTPicker4 are hidden.