Hi everyone,
This is my first post on here. I'm not particularly familiar with VBA but think I will need to use it to accomplish what I want.
I've created multiple date and time pickers for different stages of completion that the user is supposed to select which then gets assigned to another spreadsheet. The issue I find is I cannot grey out the box for stages that have yet to be completed (ie. Completed stage A on 9/13 and stage B on 9/15 but stage C still appears with the current date).
SO what I'm thinking is having a corresponding check box for each stage that when checked, allows the date and time picker for each stage to be visible. If stage 3 has not been completed then the date and time picker does not appear and will only appear once the check box has been checked.
I'm thinking something like this needs to be done:
IF Checkbox1.value = True
THEN DTPicker1.visible = True
Any help or direction would be appreciated.
Thanks