![]() If you want to edit or even move the DTPicker, you have to TURN ON the “ Design Mode” first.The date selected is LINKED to the cell you have assigned, i.e.When you have finished property setting, resizing and moving it to your designated location, you need to turn OFF the “ Design Mode” in order to activate the DTPicker To experiment it, click on the dropdown arrow to display the calendar below: Now you may want to resize the DTPicker by drag and drop a corner of it.In the Properties Windows, input the Cell Reference you want in the Linked Cell.Right Click the DTPicker (Make sure the “Design Mode” is ON).Properties Setting – Most of the time, you want to Link the value in the DTPicker to a specific cell. Pls note that the “ Design Mode” is turned ON, meaning you can edit (move/resize/change properties) the DTPicker. Now you should see the DTPicker (Dropdown box) The “ More Controls” dialog box is opened Scroll down and look for “ Microsoft Date and Time Picker Control 6.0 (SP6)” Click on “ More Controls” – the lowest right icon.Check the “ Develop” on the right under Main Tabs.Go to File Tab (or Ribbon icon for Excel 2007). ![]() In case it is not on your ribbon, follow the following steps First, you need to go to the Developer Tab. So I would like to share with you, just in case you need it. I asked that because I didn’t know its existence in Excel as it is so well hidden. UPDATE on 2: Don’t miss the video at the end of this post.ĭid you ever ask why Excel does not provide Dropdown Calendar for date selection? Like the one shown below:
0 Comments
Leave a Reply. |