LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Link control to Excel cell to click a day in month to return date

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.
 
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
double click on cell that have link, Excel will jump to the refere RW Excel Worksheet Functions 1 June 8th 08 07:19 PM
In Excel How do I return the Month for a specific date Ashok Natarajan Excel Discussion (Misc queries) 1 January 23rd 06 09:05 AM
In Excel, look at a date field and return just the month.. KC Excel Discussion (Misc queries) 2 May 20th 05 12:37 PM
Click on cell-calendar drops down-click on date-date fills cell. . George Setting up and Configuration of Excel 1 April 15th 05 08:22 AM
Excel: How do I set up a cell to click it to link a database? jp@nes Excel Discussion (Misc queries) 1 March 18th 05 07:24 PM


All times are GMT +1. The time now is 04:15 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"