Drop Down Calendar

[Guest]

I am trying to add a drop down calendar to a cell, so upon selecting the cell a calendar appears you then click on the relevant date and it then adds the date in a date format
Please help

Regards
Wayne.

 

[Peo Sjoblom]

For a possible solution see

http://www.rondebruin.nl/calendar.htm

you need MS Access installed

--

Regards,

Peo Sjoblom

I am trying to add a drop down calendar to a cell, so upon selecting the

cell a calendar appears you then click on the relevant date and it then adds
the date in a date format.

 

[Paul B]

You don't have to have Access installed, but you do need mscal.ocx
installed, it is include with Access but can be installed without it

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Ron de Bruin]

You can download the control on this webpage
http://www.fontstuff.com/vba/vbatut07.htm

I don't know if this is allowed by Microsoft???
MS remove the download links

 

[Peo Sjoblom]

That is rather picky, it is true but if you don't install Access it won't be
installed unless you customize the installation
and sit and select parts under access which to me doesn't sound very likely
even if you don't need access to run it..

 

[Paul B]

Peo, you can download just mscal.ocx off the web and use it in excel without
having to do a customize installation of access


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Guest]

How and where will I be able to find mscal.oc

Thanks for the responses

Wayne

 

[Paul B]

Wayne, the link Ron gave you has it, and instructions on how to install it,
here is the link he posted http://www.fontstuff.com/vba/vbatut07.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Guest]

OK excellent, Calendar now up and running, small problem but still an issue.
How can I get the calendar to drop off, upon selecting my date.
As it is I have to select the date from the calendar and then I have to click back in the cell in order to be able to move on to another cell.
Also my calendar is not required in the column until a specific row, no.4. How do I prevent it occurring in row 1,2, & 3.

Thanks Again

Wayne.

 

[Paul B]

Wayne, you could use something like this, will show calendar from A4:A100,
when you double click on a date it will be put in the active cell then the
calendar will hide

Private Sub Calendar1_DblClick()
ActiveCell.NumberFormat = "m/d/yyyy"
ActiveCell = Calendar1.Value
Calendar1.Visible = False
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("A4:A100"), Target) Is Nothing Then
Calendar1.Left = Target.Left + Target.Width - Calendar1.Width
Calendar1.Top = Target.Top + Target.Height
Calendar1.Visible = True
Else: Calendar1.Visible = False
End If
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

OK excellent, Calendar now up and running, small problem but still an issue.
How can I get the calendar to drop off, upon selecting my date.
As it is I have to select the date from the calendar and then I have to

click back in the cell in order to be able to move on to another cell.

Also my calendar is not required in the column until a specific row, no.4.

How do I prevent it occurring in row 1,2, & 3.

 

[Guest]

Thanks Paul

Almost there.
The problem with that coding is I can now arrow to a different cell and it takes the calendar to that cell even if that particular column has no requirement for a date.

Help

Thanks.
Wayne