userform calendar in excel 2013

[sjaveed85]

hello again,

I have below questions with which I need help/suggestions please.

1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it?

2. How do I get Calendar control in 2013? If not, the cos

 

[mole999]

calander was installed with access normally, later versions changed that, i had to borrow a work around that worked for me

 

[sjaveed85]

hello again,

I have below questions with which I need help/suggestions please.

1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it?

2. How do I get Calendar control in 2013? If not, the code?

3. I have a userform which has date label and a textbox with Dblclick event to bring thw calendar popup. The date, instead of showing up in the textbox on the form, goes to the activecell on the sheet.

Your suggestions and help is much appreciated.

 

[sjaveed85]

Thank you for replying but my post was incomplete.

 

[MARK858]

What version of 2013 are you running 32bit or 64 bit?

 

[sjaveed85]

Its 64bit. I tried to install calendar control addin - it failed with error "Access is denied"

 

[MARK858]

I'm afraid I'm unaware of a version for 64bit. There was a work around/alternative control that worked in 2010 64 bit in the link below but I afraid have no idea if it works in 2013.

http://sites.google.com/site/e90e50/calendar-control-class

 

[sjaveed85]

I am still not able to find any help on this. Addin for calendar control cannot be installed due to admin rights.

A userform with Start Date, End Date, Received Date as labels and each label with a textbox - How to do I get a calendar popup here or any other suggestions to enter the date.

Appreciate your time here. Thank you.

 

[sjaveed85]

Thank you all. This issue is resolved and Closed.