vb error compile error Expected End with

**00Able** · 11-28-2010, 07:10 PM

So with a lot of help, I have added a calendar to a userform, however, now when I test the userform to make sure it works, I get an error that reads "COMPILE ERROR: EXPECTED END WITH" as soon as I hit Submit.

I am not sure how to fix this, any suggestions would be appreciated? I would copy the code, but as I am not sure where the error is derived from I don't believe copy all the code would be beneficial.

**davesexcel** · 11-28-2010, 07:43 PM

Please Login or Register  to view this content.

where is the End with?

**solnajeff** · 11-28-2010, 07:43 PM

Hi

You need to complete any With statement with and End With statement after your last line of relevant code.

Regards

Jeff

**Richard Buttrey** · 11-28-2010, 07:44 PM

Hi

In the click event of the cmdSubmitEntry buttton, end the code with an 'End With' statement after the .txtDate.SetFocus line.

HTH

**00Able** · 11-28-2010, 08:03 PM

Thanks, Ok I finished that, and now I got another issue...new thread...

vb error compile error Expected End with

LinkBack

Thread Tools

Rate This Thread

Display

vb error compile error Expected End with

Re: vb error compile error Expected End with

Re: vb error compile error Expected End with

Re: vb error compile error Expected End with

Re: vb error compile error Expected End with

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions