Tech Support Guy banner

Linking checkbox to Date and Time Picker

660 Views 1 Reply 2 Participants Last post by  OBP
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.

Not open for further replies.
1 - 2 of 2 Posts
Can you provide a dummy example?
1 - 2 of 2 Posts
Not open for further replies.