Date Selector

's Computer Specifications

I have data validation on a cell in a worksheet. It has a list with
yesterday, today, this month, last month, this quarter, last quarter, this
year, last year. How would i program that when one of these items is
selected the start date and end date are entered into two cells onto the
worksheet?

's Computer Specifications

Check Out Chip Pearsons Web Site

http://www.cpearson.com/Excel/betternetworkdays.aspx

"Enyaw" wrote:

> I have data validation on a cell in a worksheet. It has a list with
> yesterday, today, this month, last month, this quarter, last quarter, this
> year, last year. How would i program that when one of these items is
> selected the start date and end date are entered into two cells onto the
> worksheet?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date selector combobox	Steve P	Microsoft Excel Programming	2	18th Nov 2008 11:07 PM
Month Date Selector	Jim	Microsoft Access	5	7th May 2008 05:50 PM
Creating Start Date selector in customer Form	Jon	Microsoft Outlook Discussion	1	24th Apr 2007 12:59 PM
Add date selector for 'Close Date' on an Opportunity	=?Utf-8?B?TGVpZ2h0b24=?=	Microsoft Outlook BCM	0	27th Apr 2006 05:39 AM
Creating a Date Selector in Excel VBA?	TheRobsterUK	Microsoft Excel Misc	3	25th Nov 2004 10:59 PM