Userform_Initialize Only Working Once

[Cat129]

Evening All,

Could someone help me understand what I am doing wrong please.

I am trying to create a user form (my first one)

When I use userform_initialize it works the very first time I run the script. I then close the form to make some changes and next time I run the same script I get ' Run-time error '424' Object Required.

The form is called ScannerInput, so I changed my code to ScannerInput_Initialized but then my preset inputs dont appear. Code below.

Thanks,

Private Sub UserForm_Initialize()


With DepartmentListBox
    .AddItem "Goods In"
    .AddItem "Machine Shop"
    .AddItem "Quality In"
    .AddItem "Quality Out"
    .AddItem "Goods Out"
End With


NameTextBox.Value = "UserName"


DateTextBox.Value = "Use TODAY()"


TimeTextBox.Value = "Use NOW()"


BarcodeTextBox.Value = "Scan Barcode"


End Sub

 

[Norie]

How are you closing the form?

 

[Cat129]

To start I used the 'x' in the top right corner.

I then tried

Private Sub CancelCommandButton_Click()


Unload Me


End Sub

I have tried closing and reopening excel to get it to load with initialize but now I only get the error message mentioned above

 

[Cat129]

I think it was something glitchy going on, as I had to restart for another reason and now it is working as expected. Thank you for your reply, and sorry for wasting your time.

Cat

 

[Domenic]

Although you changed the name of your userform, the declaration for the initialize event should remain as...

[COLOR=#333333]Private Sub [B]UserForm[/B]_Initialize()[/COLOR]

Otherwise you'll find that the initialize event won't get triggered when the userform is shown.