LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default "Update" calendar on userform?

Hi. Guys,
Excel 2003 - I've got a calendar on a userform displaying January 2010
This is my code:

Ualmanak.Caption = "Kies die besprekingsdatum."
Ualmanak.Calendar1.Today '<------ This works fine and highlight today's
date
'Ualmanak.Calendar1.nextyear '<------ this display the calendar as
January 2011
'Ualmanak.Calendar1.nextmonth '<------ this display the calendar as
February 2010
Ualmanak.Show
If Not bContinue Then End
On Error GoTo fout
With Ualmanak.Calendar1
Range("BronInlig!Datkies").Value = .Value
End With
Unload Ualmanak
Exit Sub
fout:
MsgBox "Die fasiliteit is nie op jou rekenaar aktief nie - sien Hulp" _
, vbInformation, Title:="Fasiliteit nie geinstalleer."
End
End Sub

My question - how do I "update" the calendar on the userform ? Or
alternatively if today = 19 May 2010 and I use either:
Ualmanak.Calendar1.nextyear '<------May 2011 must be displayed on the
Userform
Ualmanak.Calendar1.nextmonth '<------ June 2010 must be displayed

I know there's some ways around this, I also know some smartass in our
orgnisation would change the calender's date [Jan 2010] on the userform.

--
HJN
 
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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION yossie6 Excel Discussion (Misc queries) 1 June 16th 08 12:16 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Automatically click "Update Links" & "Continue" paulharvey[_13_] Excel Programming 0 June 3rd 06 05:35 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"