You can even list valid entries within the Excel spreadsheet. Type the valid dates for the drop-down in a single column. You can also use a separate worksheet -- if you do, select the cells, select the "Name" box on the left side of the formula bar and enter a name for the valid entries. Type "=" and then enter the cells containing the valid dates in the adjoining "Source" dialog box.
If you entered the valid entries on a different worksheet, type "=" and the name you entered in Step 2. He has written several articles for various websites and writes user guides and software manuals for several freelance clients.
” Now you should see the DTPicker (Dropdown box) Pls note that the “Design Mode” is turned ON, meaning you can edit (move/resize/change properties) the DTPicker. Properties Setting – Most of the time, you want to Link the value in the DTPicker to a specific cell.
• Then, from your keyboard press to show the Data Validation dialog box.i need to validate file date cell , if date is other than MM/DD/YYYY format then shows an error ' Invalid Date Format'. They facilitate creating, reading and writing constraints, not validating them. It is a library to work with XLS/X files, not a spreadsheet application like Excel. In this case it must be "dd/MM/yyyy" and not "dd/mm/yyyy", in the second case it would return incorrect date, but this kind of things are up to the date format you'll use. Scroll through the list of controls and look what’s available.There are all sorts of funky add-ins you can use in your spreadsheets! Well you can create as many of these drop downs as you like.