Compile Error:

[TonyforVBA]

Byref Argument Type Mismatch.

I got a simple variable definition problem thats driving me crazy because I know its somthing so simple but For some reason I just cant see it.

Can anybody spot the problem

Please Login or Register  to view this content.

[Andy Pope]

Is that all the code?

Looks like your missing a End Sub at least.

[TonyforVBA]

Sorry Andy, just forgot to copy and paste in, but yes, all Subs are closed off correctly.

[Andy Pope]

Really hard to say without code to compile and see the error.
Example file would make things easier.

Are all the variable names used correctly. You have a potential for public and private variables to be confused due to missing letter. Although the posted code looks fine.

NapsMonth instead of NapMonth

Is the click event code in a sheet object or userform object?

[TonyforVBA]

Hey Andy,
I have a Object 'Comandbutton' that brings up the Userfrom Object.

[Andy Pope]

Some one else maybe able to see the problem from the code you posted by I can not.

As I said earlier you really need to post example file that illustrates the problem.

[Whizbang]

Put

Please Login or Register  to view this content.

at the top of your module, and then try to compile. If you have misspelled variables anywhere, it will tell you right away, instead of you searching.

[TonyforVBA]

Ahhh I got this.

I had the below piece of code at at start of the Userform code.
I've deleted it and it has popped back in at the bottem of the code. Now it works fine.

Can anybody explain to me what this code is for and why it cant be deleted?


Private Sub UserForm_Click()

End Sub

[mohd9876]

there is no problem if you delete this code but when you double click on the user form it will automatically insert the mouse click event. if you want to jump to the code pane without inserting this module just right click on the user form and select view code

[TonyforVBA]

Ahh I see, Cheers for that lads.