| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date dropdown box?
Can I format a cell such that when I click on it, the calendar appears so I
can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
Rich,
http://www.vbaexpress.com/kb/getarticle.php?kb_id=21 rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
i knew there was a better one
http://pop-up-excel-calendar.billing....qarchive.org/ I use yet another one, but forgot where I stole it.... :-) rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
found it....
http://mc-computing.com/Databases/MS...r_Example.html "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
sorry, that one was Access this is the xls version
rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
It isn't available as a simple icon on a toolbar?
-- Rich D Armstrong Custom Homes Redmond "rdwj" wrote: Rich, http://www.vbaexpress.com/kb/getarticle.php?kb_id=21 rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
Sorry, didn't get the link.
-- Rich D Armstrong Custom Homes Redmond "rdwj" wrote: sorry, that one was Access this is the xls version rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date dropdown box?
rdwj:
On your last response I think you intended to include a link for the calendar box for Excel. It didn't make it. Could you please send? Thanks -- Rich D Armstrong Custom Homes Redmond "rdwj" wrote: sorry, that one was Access this is the xls version rdwj "Rich D" wrote: Can I format a cell such that when I click on it, the calendar appears so I can click on a date and it will go into the cell? If so, how? thanks. -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create a "by date" dropdown list from other excel docs | Excel Worksheet Functions | |||
| Date Dropdown Question | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
Linear Mode
