Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar not in a cell
I need a popup calendar that is called from a CmdButton that will return the
value chosen to a varable. The needed format is ..NumberFormat = "m/d/yyyy;@" Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar not in a cell
There are several ways to do it, the one you choose will depend on how
exactly it is implemented. A standard button could launch a user form with a calendar on it, set the click event to ActiveCell.Value = Calendar1.Month & "/" & Calendar1.Day & "/" & Calendar1.Year or, as in my xl2003 on the worksheet toolbox you can add a microsoft date time picker. -- -John Please rate when your question is answered to help us and others know what is helpful. "treasuresflemar" wrote: I need a popup calendar that is called from a CmdButton that will return the value chosen to a varable. The needed format is ..NumberFormat = "m/d/yyyy;@" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming |