Thread: Initializing a Userform

Hello Everyone,

I'm conducting a UserForm tutorial posted on following site:

http://www.excel-vba-easy.com/vba-us...excel-vba.html

but I can't seem to launch the form to test it. When I click on the command button that I have created to do this I recieve the error :

"Runtime Error '424' Object Required"

I can't seem to find my mistake. Can anyone offer anyhelp?

I've attached the workbook.

Thanks Everyone, you've all been great since I first signed up!

Hi,

In the UserForm_Initialize() event handler, check for some incorrectly named controls.

For example, in the code:

'Empty NameTextBox
NameTextBox.Value = ""

But the control is called NameTestBox

The SetFocus line is failing & causing an error.

Use Option Explicit & you will pick up the mistake

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save