PC Review


Reply
Thread Tools Rate Thread

Date Selector

 
 
Enyaw
Guest
Posts: n/a
 
      11th Dec 2008
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?
 
Reply With Quote
 
 
 
 
Office_Novice
Guest
Posts: n/a
 
      11th Dec 2008
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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:42 AM.