That's what I thought so I have put my original project with loads of variables aside while I try and figure out what is going on. So I just have a Userform with a Label and Command button and the code for this is
Private Sub CommandButton1_Click()
Unload UserForm1
End Sub
Private Sub...
Pulling my hair out here. It's a while since I did any VB and of course stuff has changed but.... I create a userform and add a listbox. A line of code in the initialize event adds one item for test purposes. I then create a module that loads and shows the form. Save the project, close it and...