Calendar object in cells

[kingsp]

Hi there. I am trying to use a calendar control in two separate cells.

I have two cells for a user to enter dates 'Start Date' (Cell F8) and 'End Date (Cell G8) - located on Sheet1 'Search'.
I want the calendar to pop up when the user select the cell and for it to hide when they enter the date.

I've managed to get the calendar control to pop up for the 'Start Date' but can't manage to get it to hide once the date is selected.
I've then run into problems trying to do the same for the 'End Date' as the calendar object won't hide.

In summary - I just want to try and have a calender control in each of the cells F8 and G8 on Sheet1.

Any help or guidance would be greatly appreciated.

many thanks

[David A Coop]

Hi Kingsp,

I can't get your workbook to run as all on my system - the forms seem to be missing and the macro can't find Calendar1 etc -, however, can you try adding Unload.Me as the last line in your macro and see how you go.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

[kingsp]

Hi David,

Thanks for your reply. The workbook was created in Excel 2003 (needs upgrading I know) - I just checked it there and it works on my system.

I managed to get the first calendar working by using

Please Login or Register  to view this content.

at the end of the routine.

I cannot however get the second calendar to work. I copied over the code from Calendar1 and Calander2 just stays static on the worksheet. The code I am using is:

Please Login or Register  to view this content.

thanks for your help in the first instance, it put me on the right track.

Simon.

[David A Coop]

You're welcome.

I did try your model in XL2003, but it still didn't work - it must be pointing to something on your machine that I cant see.

Did you try the Unload.Me? I'm no VBA expert, but it may be that while you can't see it, the object may still be there, and preventing you from using it again.


Thanks for reply, I'm pleased you're now on your way.

By the way - thanks for attempting to place the HTML markers around the code - but you got the syntax wrong. The / goes before CODE. I find it easier to click the # icon at the top of your message/reply window.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

[kingsp]

Apologies re the code tags - I should have double checked. They are now entered correctly.

Thanks again David. I used Visible = False at the end of the routine for the first Calendar and it worked. I am still stuck in trying to figure out how to make the second calendar object hide after selecting a date. I've attached another sample (which hopefully works) showing how far I've managed to get.

many thanks

Simon

[David A Coop]

Hi Simon,

Sorry for the delay - I was away all day yesterday.

I have tried your new post. I can open it, and see the Calendar, but the macro doesn't work. I get a Compile error: Can't find project or library message.

Perhaps your Calendar is in your Personal.xls file or somewhere else - I can't find it!

Any way, from what I have read - Unload Me should be at the end of your macro. (I note that I inadvertently included a dot in my earlier post.

HOWEVER, this may not work. I have just discovered this on the web http://www.experts-exchange.com/Soft..._26449160.html

I haven't followed it through, but it may help.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

[kingsp]

I managed to solve the issue with the information here http://www.fontstuff.com/vba/vbatut07_2003.htm.

It works great!

Thanks again for your help David - much appreciated.

best regards

Simon