UserForm.Show erroring out, requires object

[TKCZBW]

My code launches a userform (userform1) when a user opens a particular worksheet in the workbook. Uses the 'UserForm1.Show' command.

On my machine this works fine (on excel 2003,2007 and 2010), but on another user's machine it errors out and states that an object is required. On debugging, the 'Show' line is that causing it. I've double checked it on my machine and it still runs fine for me.

As far as I was aware there is nothing on this line referring to (or that could refer to) an object. Any ideas as to the cause?

Code below

Thanks,

Tom

Please Login or Register  to view this content.

[buran]

well, strictly speaking, the UserForm is an object, but I assume it's in the workbook

[TKCZBW]

Yep, it's in its usual place under Forms.

All other answers I've found seem to have been solved based on a mis-spelling. No such luck here, especially as it run's on my machine but not others'.

[LJMetzger]

Hi TK,

On my computer (Excel 2003), whenever there is an error in 'UserForm_Initialize(), the error appears on the 'UserForm.Show' line. You may want to take a look at the code in the UserForm module.

Lewis

[TKCZBW]

LJMetzger, I just realised the same thing and that's the answer.

Many Thanks!