Invalid qualifier Error

Okay, I've been working with this for a while now, cobbling this together from various bits of found code and my own somewhat rudimentary knowledge of VBA. The below code is what occurs when button Enternew is clicked and is supposed to take the values from the various input boxes in the userform and put them into the next available row in range A9:A500. But when I run it I keep recieving an invalid qualifier error. I've tried making it a doubleclick macro and a couple of other things but I just cannot figure out what is wrong. Any thoughts?

Please Login or Register  to view this content.

Can anyone see what could be causing the error? I'm at my wit's end.

Cheers,

Thanks for your help Royuk, it certainly made it a lot easier to sort out everything else. I eventually managed to do more or less what I was after with a back to basics approach. My efforts are below in case anyone's got any critique or improvements which are always welcome. I know it's not a particularly efficient way of doing what I'm after but it does the job and at the moment memory efficiency and the like aren't really issues.

Please Login or Register  to view this content.

Thanks for your help on this and my other queries all.

Argh, nevermind, it's still not quiet working properly. The reason I had reversed the copying order in the list above is that it was copying the box value into everything between column A and the offset column. Unfortunately there's a few columns in that range that are hidden with formulae that are used for varous lookup and sorting functions. Is there any way to get the code I've cobbled together copy the value into only the offset cell and not every cell between there and the original?