Calendar Box

[guitarist00]

god evening all,

im trying to create a calendar box like the one in the websites . when you press in that box. it will show you a calendar you can choose the date from it such as in the following website :

http://www.britishairways.com/travel/home/public/en_gb


note that im using Excel 2010. also i tried the following :
calendar box.jpg

if you will suggest to do the following :
Developer - Insert - More control - microsoft outlook date control

then it wont work for me *** when i choose that a message will come and say : Cannot insert object. acutally none of the " more control " can be insert for some reason

apprecitae your help guys

[lilsnoop]

Hello guitarist! Do you want the calendar to pop up when you click on a cell in a particular column in your excel sheet or are you using a userform and want a calendar to pop up when a button is clicked and then populate the date in a particular cell in your workbook?

[guitarist00]

i need to click to a button . when it pop up , i will choose. then it will show in a specific column

thanks lilsnoop

[lilsnoop]

Try this sample file. I found this on the web (source I can't recall) but I believe this sounds like what you want. Whatever cell you've selected the calendar will populate the date in.

[lilsnoop]

Here's another that works on the same principle...

[guitarist00]

the system told me the following for both files:

could not load an object because its not available on this machine



whats the problem ?

[lilsnoop]

Might be Excel 2010 ....see if this one works..

edited to add: If this doesn't work this link may explain why: http://www.logicwurks.com/CodeExampl...erControl.html

[guitarist00]

microsoft Visual Basic for Application:
Compile Error:
Cant find project or library
and it select the following : Public Property Get Parent() As Control but not yellow

[guitarist00]

im not sure if this is the problem. but my microsoft office has left 28 days to register. i tried to write this command as the website you sent me %systemroot%\System32\regsvr32.exe mscomct2.ocx
im using windows 7 32-bits.
but it failed. ill ask the IT department tommorow and find out what the problem . thanks fr your help anyway. ill fix the problem and try to open these attached filed.

appreciate it my friend )

[lilsnoop]

Best of luck to you!