Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Calender Help

I have a userform which uses the Calender Control but I need the calender to
show todays date,

I also have a probloem when I access this file on another computer on my
network The font size of the calender is impossible to see. When I try to
change the font size it comes up with the error - object not found. I
copied the file to the computer which I was using by a disc, and the same
problem happened.

The excel where the project was first written was office pro 2003, the
other computer is running office 2000

Thanks in advance

Greg


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default Calender Help

Not sure about the "object not found error", but this is what I use to
display the Calendar Control:

Option Explicit
Sub ShowCalendar()
Dim newDate As String
Load frmCal

newDate = Format(Now(), "mm/dd/yyyy")

frmCal.Calendar1.Value = newDate
frmCal.Show
End Sub

I hope that helps.
--
Regards,
Ron

Reply
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
pop up calender Norm Excel Discussion (Misc queries) 1 April 28th 10 05:06 PM
pop up calender Norm Excel Discussion (Misc queries) 2 April 15th 10 03:13 AM
pop up calender pezcore Excel Discussion (Misc queries) 2 October 18th 07 02:15 PM
Calender Help Alexanderj Excel Worksheet Functions 3 November 10th 05 02:10 PM
Calender Help Greg B... Excel Programming 10 March 3rd 05 06:07 AM


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

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"