Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-10-2020, 01:17 PM
chriscla chriscla is offline date picker in dropdown list Windows 10 date picker in dropdown list Office 2013
Novice
date picker in dropdown list
 
Join Date: Mar 2020
Posts: 18
chriscla is on a distinguished road
Default date picker in dropdown list

Hi

I'm trying to have a date picker as one of the choices in a dropdown list, but since the items to choose from are only text, I'm stuck.
The situation is as follows:
I have a dropdown list with two choices: the check of the installation is done ('doorlopen' in the code below) or not done. When the check is not done, there is text: 'not done'. But when the check has been done, I would like to have again two choices: date unknown or date of check. This date of check should be entered by a date picker.

Is this possible or am I wishing for the impossible?



The code I'm using now is (thanks to GMayor):

Code:
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
  Dim i As Long
  Dim oCC As ContentControl
      With ContentControl
          Select Case .Title
              Case Is = "doorlopenJN"
                  If .ShowingPlaceholderText = True Then
                      Set oCC = ActiveDocument.SelectContentControlsByTitle("doorlopenTekst").Item(1)
                      oCC.LockContentControl = True
                      oCC.Range.Text = ""
                  Else
                      For i = 1 To .DropdownListEntries.Count
                          If .DropdownListEntries(i).Text = .Range.Text Then
                              Select Case .DropdownListEntries(i).Text
                                  Case "doorlopen"
                                      AutoTextToCC "doorlopenTekst", ActiveDocument.AttachedTemplate, "DoorlopenJa"
                              End Select
                              Exit For
                          End If
                      Next
                  End If

        End Select
    End With
End Sub
(This is with an autotext to be inserted after the choice in the first combobox), maybe this would work also but I can't figure out how.

Thanks for any help.
Chris
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
date picker in dropdown list Selecting a Date in Date Picker and Having it change dates throughout joshuaran Word VBA 2 03-14-2018 09:24 PM
date picker in dropdown list Date picker content control to always show current date. lucky16 Word VBA 2 07-01-2016 01:14 PM
dropdown lists and date picker added to word doc. greg__reynolds Word 3 05-19-2014 12:19 AM
Possible to link a date picker to another date picker? tubbz Word 0 05-07-2014 01:23 PM
Date picker trintukaz Excel 0 12-30-2011 12:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft