Compile Error upon selection

[bralew]

Hi, I'd like avoid a compile error in my selection in my combo box, The form works fine but i receive a compile error when i select an option:

Please Login or Register  to view this content.

[TMS]

Please post a sample workbook with some typical data and ALL the code.

[xlnitwit]

Hi,

You must remove either of the first two lines of code. It is incorrect to have two declaration lines.

[TMS]

It is incorrect to have two declaration lines.

That's why I asked to see all the code so we can see the context.

I wouldn't really expect anything to compile/execute with something like that present.

[xlnitwit]

I wouldn't really expect anything to compile/execute with something like that present.

It will however. The error will only trigger when the change event is triggered- unless you manually attempt to compile the project.

[bralew]

Thanks chaps, I could see it when you pointed it out, Many Thanks