Date Input from Pop up calendar

Hi,

Can anyone help?

I would like to force input of a date format by having the user select a date from a calender, either in pop up form or from a drop down and the date is inserted into the field.

Thanks.

some more info would be nice are you entering on a worksheet or a userform? what sort of outcome are you looking for etc.

dont just assume people will just draw up a full working version of what you want by just giving as little detail as possible. As there are various methods of doing things in Excel and each have their limits.

i apologise if i was too vague, i do not expect the whole code answer i was more after what i need to include, ie. add ins or i don't know, hence why i am asking.

i have created a form where the users enter their data into text fields then those fields are entered onto the spreadsheet.

i would like to force them to put the correct date by, on the form, having them click on a date on a pop up, or somesort, of calendar. that date is automatically then put into the text box.

Not after the whole code for my project just how to or where to find info on the calendar input.

have looked in help but they do not seem to have calendar pop ups in VB help.

Ok I see what you are looking for now. Just wanted you to sweet a bit before you get an answer

Anyway, there is a control for a calender if you are using a userform. if you click on additional controls in the toolbox window you should see something like Calendar Control and then a version number eg. mine was Calendar Control 9.0. if you activate that control you can just move the calendar either straight across onto your userform instead of even having a text box for them. then when you transfer the value use something like range ("a1").value = userform1.calendar1.value . I have supplied a working example for you.

The only problem is that it will only work if the users machine has the tool installed some machines do not have this tool installed. So you will need to insure machines have got it installed if they dont here is a great tutorial which includes the files http://www.fontstuff.com/mailbag/qvba01.htm.


Hope this helps you.

If you need any more info just shout.