Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel VBA - date format and Active X

Posted on 2011-02-19
3
Medium Priority
?
310 Views
Last Modified: 2012-05-11
Hi

I have no idea what happened to the Active X calendar control in Excel 2010
so I have built 3 ComboBoxes with day, month and year.
What VBA do I use to gather the integer date from these 3 boxes and compare
it to a cell value of "2010/12/31"
thanks
0
Comment
Question by:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 2000 total points
ID: 34932565
If I am not wrong then MSCAL.OCX is only available for 64 bit Excel 2010. I have a 32 bit system and I am also having a tough time with that.

Sid
0
 

Author Closing Comment

by:Murray Brown
ID: 34932591
Thanks very much Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34932604
murbro: I suggest you should have waited for some more time before selecting an answer. I am sure there are several mvp's who could have confirmed what I said is correct or not.

Sid
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question