Problem with pop-up calendar

Hey guys,

I'm new to this forum and I've only been using VBA for a few months. I am working on a macro that uses a userform in which a user can enter information about incoming parts. One of the entries in the form is the date on which the part came in which is selected using a pop-up calendar and then stored into a combo box. Once the user types in all of the data properly, the part is entered into an excel sheet.

The only problem that I am having is that you have to press on a date twice (instead of the desired once) in order to be able to press OK. If you only select the date from the calendar once and try pressing OK, the macro crashes for some mysterious reason.

I've been trying to fix this problem for a few days now with no luck. Any ideas?

Thanks a lot,

Rusty

Hi,

Can you attach a sample workbook with the userform and code in it?

Dom

sure here it is

Sana worksheet.xls