Show a Userform

[bensox]

Hi

I'm new to Userforms and having trouble getting the form to show. I have created a form in VBA which I want to show when the workbook is opened but cannot get it to show at all, even to test it out. I have added the following code into 'this workbook'

Please Login or Register  to view this content.

and also tried

Please Login or Register  to view this content.

but nothing happens when I save, close and re-open the book.

What am I doing wrong?

[JosephP]

from where do you call the GetUserNameandWeek sub?

[Norie]

Is the form called NameDataForm?

If it is then it should show when you run the first code you posted.