Object Required error when Calendar added

[Donal28]

Hi All

I have just added a calendar to my my userform called Calendar1 but when I now launch the userform using a button I get the error "Object Required". The code behind the button is

Sub Open_B1_29000()
B1_29000.Show
End Sub

Any help on this would be very much appreciated

Regards
Donal

 

[Andrew Poulsom]

Do you actually get an error on that line, or on some line in your UserForm module? Is B1_29000 the name of a UserForm? To see if the error is in the UserForm module check 'Break in Class Module' on the General tab of the Tools|Options dialog.

 

[Donal28]

Thanks for the reply Andrew I did as you said and see that I had changed the a textbox(which I was previously using for the date) to the Calendar1 but was still referencing the textbox somewhere else in the program which was giving the error. I previously had

date.Value = ""

but changed this

Calendar1.Value = ""

which fixed the problem. Thanks for your help