Having trouble making dates and calendars work

[johnw993]

See attached my rather simple code. It returns errors at every click. What am I doing wrong?

Please Login or Register  to view this content.

Any feedback will be greatly appreciated.

John

[6StringJazzer]

Whenever you are asking about VBA errors, always give the exact error message you get, and which line causes the error (highlighted in yellow when the error occurs). Your description leaves a certain amount of guesswork about what's wrong.

You did say on each click, so I am looking at the click events. You have this line of code:

Please Login or Register  to view this content.

There is no variable Parent declared or assigned. What is it that you want to go in that cell? I don't think this will cause a runtime error but it probably isn't doing what you intend either.

It might be helpful to attach your file so we can run the code.