excel 2003 Drop down Calendar

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Apr 29, 2011

• #2

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

 

Upvote 0

M

MickG

MrExcel MVP

Joined

Jan 9, 2008

Messages

14,841

• Apr 29, 2011

• #3

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

 

Upvote 0

M

MWhiteDesigns

Well-known Member

Joined

Nov 17, 2010

Messages

646

Office Version

1. 2016

Platform

1. Windows

• Apr 29, 2011

• #4

VoG said:

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

Click to expand...

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.

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Apr 29, 2011

• #5

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

Code:

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

 

Upvote 0

M

MWhiteDesigns

Well-known Member

Joined

Nov 17, 2010

Messages

646

Office Version

1. 2016

Platform

1. Windows

• Apr 29, 2011

• #6

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?

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Apr 29, 2011

• #7

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

 

Upvote 0

M

MWhiteDesigns

Well-known Member

Joined

Nov 17, 2010

Messages

646

Office Version

1. 2016

Platform

1. Windows

• Apr 29, 2011

• #8

VoG said:

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

Click to expand...

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Apr 29, 2011

• #9

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

 

Upvote 0

M

MWhiteDesigns

Well-known Member

Joined

Nov 17, 2010

Messages

646

Office Version

1. 2016

Platform

1. Windows

• Apr 29, 2011

• #10

VoG said:

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

Click to expand...

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

 

Upvote 0