Adding drop down calendar in excel 20139/22/2023 ![]() If this post helps, then please consider Accept it as the solution to help the other members find it. At this point the cells you had selected will only. In the Source text box, enter the following: Yes, No, Maybe. In the Validation criteria section, change the Allow drop-down box from Any Value to List. If you still could not figure out what to use, please provide more details of your modification/what you have done on the App/Controls so that we could show you the proper solution. Select Data Validation from the Data Tools group. For example, if I use Distinct function as the Items of the Dropdown, the result table only have one column "Result", I will have to set Update to ![]() You may try and use other column name if the selected display field is not "Value". You can decide which column to display in the dropdown area of the Dropdown box via changing the Value field of the control: The point is the Items property of the Dropdown1, it should be a table with one or more columns. Since you need to update to the excel table, you will need a Text value to update and get from the Dropdown1 items. There is an Outlook Date Control but I don't know what it does and it will not embed in Excel. ![]() Hi can see you are using (Table1.Textvalue) in the Update property, which I could not understand. How to add a DROP DOWN CALENDAR to a cell in Excel 2013 I have attempted to use 'MORE CONTROLS' in ACTIVEX CONTROLS but there is no calendar listed.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |