LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default How to create a dropdown list of dates with validation?

Im trying to make a drop down list with dates, but cannot do it

here is the code in vba editor
(I have also tried it with record macro to work backwards)

dim curdate as date
dim day1
dim day2
dim datearray(3) as date

curdate= Date
day1=curdate +1
day2=curdate+2

datearray(1)=curdate
datearray(2)=day1
datearray(3)=day2

with range("e5").validation
.add xlvalidatelist, xlvalidalertstop, xlbetween, datearray
.incelldropdown = true
end with

Thanks
John


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Dropdown list is not available Makelei Setting up and Configuration of Excel 1 March 25th 10 08:18 PM
Validation dropdown list is not available Makelei Excel Discussion (Misc queries) 1 March 25th 10 08:06 PM
Validation Dropdown list starts at b ottom of list Tonso Excel Discussion (Misc queries) 2 March 17th 10 05:21 PM
IF + respective Validation Dropdown List karenc Excel Worksheet Functions 2 November 27th 08 09:48 AM
How to create Dropdown lists not using Data Validation Catlady Excel Discussion (Misc queries) 3 December 13th 06 05:06 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"