| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Calendar help requested: default to 1st of prior month
Using Calendar in a 97 UserForm to enter dates into a textbox. I want
it to default to the 1st of the previous month on opening. I tried using the month property set to 0 and then using PreviousMonth as the Sub but suspect that it won't change after the next month comes around. Made a feeble attempt at trying Today -30 just to get to any date last month. Any suggestions? Thanks! Tim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Calendar help requested: default to 1st of prior month
Calendar1.Value = DateSerial(Year(Date), Month(Date) - 1, 1)
-- Rob van Gelder - http://www.vangelder.co.nz/excel "timh2ofall" wrote in message ... Using Calendar in a 97 UserForm to enter dates into a textbox. I want it to default to the 1st of the previous month on opening. I tried using the month property set to 0 and then using PreviousMonth as the Sub but suspect that it won't change after the next month comes around. Made a feeble attempt at trying Today -30 just to get to any date last month. Any suggestions? Thanks! Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calendar, if paid on date, not count prior | Excel Worksheet Functions | |||
| 15th of prior month | Excel Worksheet Functions | |||
| calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
| dates, 1 month prior | Excel Worksheet Functions | |||
| Prior Month | Excel Discussion (Misc queries) | |||
Linear Mode
