Calendar selection not working for TextBox in frame

I got the pop up calendar in the attached file from torachan which I really like, but it is generating the error Run-time error'438': Object does'nt support this property or method.

From scouring other forum posts I think the issue is something to do with the fact the TextBoxes that I want the date to appear in are in a frame (they were not in a frame when torachan originally gave me the calendar solution), but a solution is not that clear to me, so any help solving this would be much appreciated, or alternatively if you tell me frames are bad news and should be avoided that would also be helpful.

To recreate error, open UserForm1, click in any of the date TextBoxes on bottom right of form and select a date.

As @Norie notes you need to recognise the frame as the control container.
torachan

Please Login or Register  to view this content.

Thank you both @Norie and @torachan, problem solved!

@chris01395
you had a previous question with regard filtering, on seeing the file attached it reminded me.
I have attempted to incorporate it within your file, regrettably I have had to give up as there was too much editing to do and I had not the time spare.
So I have attached something similar that I had posted to to previous members problem on similar lines.
The textbox filters (similar to your small lists) however look at the coding for the large listbox - one lookup line compared to your 20+ lookups.
The basics of the search on the filtered listbox are the list.listindex is used to identify the contents of a unique cell, this is then used to identify the table row, from which the textbox contents can be read in.
The sheet is only read once, with your method using worksheet functions the sheet is read 20+ times making for a very slow program.
Lastly the best tip ever, declare 'Option Explicit' as your very first program line, followed by all your variables at the head before any Subs, this allows the variables to carry between all Subs and when you run debug you will find error checking far more informative.
Remove the apostraphe from the word "Stop" in the code to see the relationship between listindex and the search table row.
torachan.

Thanks @torachan I will take a look at your file.

I have now added the Option Explicit and it threw up several missing variables not being set, but I was able to to fix these pretty easily (so I must be learning something )

Just to close out this calendar question, how do I alter code if I want to use it in multiple places for example in UserForm1.Frame2 and UserFrom3.Frame3 (more likely to follow); I tried the following with no success;

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Use @Norie's code - then look for the code below in the UserForm and add similar for your new textbox.

Please Login or Register  to view this content.