Pop up activated on clear contents code

Hello,

I have a small workbook that copies 4 cells to a database list as per the code below, 2 of the fields activate a pop up calendar for date input on a button push the data is transfered to the sheet and the cells are cleared, however on the clear contents parts at the bottom of the code it reactivated the pop up calendar, is there a way of not having this pop up when clearing the contents.

Please Login or Register  to view this content.

thanks reg

Try this

Please Login or Register  to view this content.

You need to change im to Dim, I didn't copy it properly.