Excel 2008 : Calendar PopUp in Excel 2010

[pansovic]

I have created an Excel calendar popup in Excel 2007 and I want to share file with a computer that has Excel 2010 installed. All macros are working except for the calendar popup. Anyone knows how to create Calendar popup in Excel 2010?

[jwright650]

What kind of calendar did you use in XL2007?

[pansovic]

This is what I have written in Visual Basic

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim isect As Range

If Target.Cells.Count > 1 Then Exit Sub

Set isect = Intersect(Target, Range("$A$2:$A$1048576"))
If Not isect Is Nothing Then
frmCalendar.Show
End If
End Sub

[jwright650]

You can go here to see if this calendar will work for you. You can copy the userform and code over into your workbook and use a command button or something to call the userform up(nevermind, I see that you are using Column A in your worksheet to call it up)....open the attached workbook and see if the calendar works for you before doing too much work.

[pansovic]

I get error message "Cannot find project or library". Marked is the following:

Private Sub UserForm_Initialize()
ThisDay = Date

[jwright650]

I get error message "Cannot find project or library".

Yeah, I get that on some machines, while on others there are no errors....I thought maybe your machine might be one that does OK.
I'd love to know what the hangup is...still trying to solve the mystery.

Weird because it runs fine in this file(see attached)...try this one.

[pansovic]

I get exactly the same mistake

[jwright650]

I don't know....I'm sorry that I wasn't able to help.
I opened it up and used the Scrap Sales 2011.xls before I attached it and it worked for me.

Hopefully someone more knowledable in VBA will chime in and help us figure out why it won't work for you.

[royUK]

See the alternatives here

DatePickers

[pansovic]

I am not sure if this is really practical. For example if you want the short format you always have to double-click and change format. Seems like there is no configuration that you always have the short format. Neither can you work with the date as TODAY(), etc. I have yet not tried it on Excel 2010. Will do that tomorrow

[jwright650]

Ok, here is my last ditch effort. I'm out of ideas. I used one of royUk's UserForm Calendars in this file....see if this could work for you.

[romperstomper]

Excel 2010 does not come with a calendar control. The "can't find project..." error is caused by missing references -in this case probably the calendar control!

[jwright650]

What I posted in post#11 works on my XL2010 here at home.

[romperstomper]

Yes - that's not a Calendar control.
My point was to explain why the problems were occurring.

[jwright650]

RS, yes I understood the intent of your post. I was just stating that for the OP.

Is the calendar build that I was using in post#6 a calendar control?....I thought it was using code to build the calendar...creating the form and building the buttons and everything appeared to be done by code.

EDIt: that file in post #6 opens fine on this XL2010 also

[romperstomper]

I couldn't tell you at the moment - I'm posting from my phone.

[jwright650]

Ahhhh, technology on the go...LOL

[pansovic]

I have exact the same problem. Thanks for the effort though no solution yet.

[jwright650]

Figured out something this morning....try these two files and see if you can use the calendar in them. Rev2 has royUK's calendar in it....Rev3 has the calendar build that I've been using.

[pansovic]

Both are working in Excel 2007 and 2010. Though now I will need the same when I click on a cell that automatically opens me the calendar. If possible I as well prefer a calendar that moves to other month with 1 click at right or left of calendar and not thyat I have to pinch first year, month and date.

[Lungfish]

Hi all, is this thread still active???

I am wondering how, when you select the date from the userform (in "Scrap Sales" example), to get that date to paste into a cell?

Cheers
Martin