Issue with User Form Data Definition

I am running a userform to input data. Once entered calculations are made and the data is place into the file but I keep running into errors with the output strings. My code is:

Please Login or Register  to view this content.

But when the program gets to the data placement for EndDay I get an Error "Object doesn't support this property or method." or if I define EndDay.Value I get "Object Required".

How do I fix this issue?

Which line does the code error on? What are your definitions of all you variables present (or have you defined them)?

It has the error with the statement

Please Login or Register  to view this content.

Spell, TimeEntry, DurationList are values entered into the userform. All other defined are listed. I have tried listing it as a Date variable, but that does not help the issue.

If you haven't dimensioned it as a range then it isn't going to have a Value property. In VBA, simple scalar variables (of which it would appear sEndDay is one) don't have any properties as they are not objects. Have you tried simply removing the .Value on the end of the code ie to:

Please Login or Register  to view this content.

Yes I have. That is what generates the Error "Object doesn't support this property or method."

I went back and retype all of the lines and there must have been a typo because now everything works.