Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Calendar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dewi... - 26 Jun 2007 09:23 GMT
Had some nice code off a magazine to make the calendar

The code only allows you to do one date at a time, it would be nice if
you could just click on a cell and then click a date as often as you
want. Quicker to do Ctrl and Colon and then edit the dates as it is.

Here is the code
this is the  forms
-----------------------------------------------------------
Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
End Sub

Private Sub userform1_activate()
Me.Calendar1.Value = Date
End Sub
----------------------------------------------
then to make it show

Sub ShowCalendar()
Calendar.Show
End Sub
---------------------

thanks
Ron de Bruin - 26 Jun 2007 17:29 GMT
Hi Dewi

See this page
http://www.rondebruin.nl/calendar.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Had some nice code off a magazine to make the calendar
>
[quoted text clipped - 21 lines]
>
> thanks
Dewi... - 26 Jun 2007 18:33 GMT
> Hi Dewi
>
[quoted text clipped - 31 lines]
>
> - Show quoted text -

many thanks, will work through it later.
Ben - 17 Sep 2007 20:04 GMT
Ron,

The link below worked well.  I have an additional question.  How do I tell
Excel to display the calendar when a particular cell is clicked?  It is
almost like data validation... I don't want the user to click a button, would
just like the calendar to be displayed on cells that require dates.

Thanks - Ben

> Hi Dewi
>
[quoted text clipped - 26 lines]
> >
> > thanks
Ron de Bruin - 17 Sep 2007 22:07 GMT
Hi Ben

The code on my site is doing what you want
If you use the userform example you can also use the selection change event to
open the userform when you click on a cell.

See de code on my page how I run code when I select a cell in a range

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Ron,
>
[quoted text clipped - 35 lines]
>> >
>> > thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.