ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert calender into a cell (https://www.excelbanter.com/excel-programming/357838-insert-calender-into-cell.html)

Deepa7476

Insert calender into a cell
 

hi
i what to know

- "how to insert the calender control in to a cell?"so that i will
avoid the hassle of manually entering the date
- Is it possible to extend this functionality to the entire column?
- Is it possible to create a look-up (with a drop box having list of
values)? to an individual cell.

thnkx frinds


--
Deepa7476
------------------------------------------------------------------------
Deepa7476's Profile: http://www.excelforum.com/member.php...o&userid=33106
View this thread: http://www.excelforum.com/showthread...hreadid=529141


Tom Ogilvy

Insert calender into a cell
 
Ron de Bruin provides some sample code at his site:

http://www.rondebruin.nl/calendar.htm

For the lookup, look at Data=Validation and select the list option. For
more information, you can look at Debar Dalgleish's site:

http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy



"Deepa7476" wrote:


hi
i what to know

- "how to insert the calender control in to a cell?"so that i will
avoid the hassle of manually entering the date
- Is it possible to extend this functionality to the entire column?
- Is it possible to create a look-up (with a drop box having list of
values)? to an individual cell.

thnkx frinds


--
Deepa7476
------------------------------------------------------------------------
Deepa7476's Profile: http://www.excelforum.com/member.php...o&userid=33106
View this thread: http://www.excelforum.com/showthread...hreadid=529141




All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com