excel 2003 Drop down Calendar

[MWhiteDesigns]

Hey Guys,
Is it possible to create a drop down calendar in 2003?

Basically i have a cell that displays the date. I would like to be able to click on the date and it open a calendar to choose a date from. Is that possible?

 

[VoG]

Take a look here http://www.fontstuff.com/vba/vbatut07.htm

 

[MickG]

Hi, You can place a "Calendar" Control in a Userform !!

 

[MWhiteDesigns]

Take a look here http://www.fontstuff.com/vba/vbatut07.htm

I followed the steps here. Calendar works great. However when i run the macro to open the calendar, it opens all the way to the left in the middle. Anyway to adjust where it sits on the page when you run the macro?

example: Click on the image to run the macro and it populates right beside where you clicked.

 

[VoG]

Positioning userforms is a bit tricky. You could try this in the form's code module

Private Sub UserForm_Initialize()
Calendar1.Value = Date
With Me
    .Top = ActiveCell.Top
    .Left = ActiveCell.Left + ActiveCell.Width
End With
End Sub

Otherwise see http://www.cpearson.com/excel/FormPosition.htm

 

[MWhiteDesigns]

Thanks, ill give that a shot.
In addition, i sent my file to someone to tinker around with to see if it were functional. They ran into a small problem. They receive an error stating the page has links to other data sources. Which is the Personal.xls that is refered to in the above link for the calendar. how do i move that so others wont receive that error?

 

[VoG]

You can take the code out of personal.xls and put it in a regular module in the workbook containing the calendar.

 

[MWhiteDesigns]

Take a look here http://www.fontstuff.com/vba/vbatut07.htm

In the above link, it states to create the personal.xls form. Do you have to input this information here?

 

[VoG]

It doesn't have to go in personal.xls

Here's an example of a self-contained workbook with a calendar http://www.box.net/shared/lxhg70lc0n

 

[MWhiteDesigns]

It doesn't have to go in personal.xls

Here's an example of a self-contained workbook with a calendar http://www.box.net/shared/lxhg70lc0n

Unfortunately I am at work and filters are not letting me view the page. Where should i put the userform in the vba folders?