How to get date clicked on monthview to my textbox on userform?

I have a userform with a textbox for date. Besides this textbox, I have a small date icon that pops-up a calendar(MonthView1). When I click on a date in the monthview1 calendar, it does not get an entry into the textbox. I also tried using [Userform].[textbox].value= dateclicked logic, but it does not seem to work. Can anyone please take a look at it.

Please Login or Register  to view this content.

Thanks,
excelkann

I tried both of these below
Txt_Prod_Loc_Date.Value = DateClicked

Txt_Prod_Loc_Date.Value = MonthView1.Value

But I see a "Run-time error 424, object required". I am expecting the calendar to close, once date has been clicked. So, I am using unload me in my procedure. Am I missing anything more in the code?

Run time error 424 was happening because the program was not able to see the textbox present on a different User Form. So with

Please Login or Register  to view this content.

the problem is solved. Add_Inv is my user form.

Thanks very much @ AlphaFrog for your help. Greatly appreciate it.

Regards,
excelkann