Put the code below in a separate module from that of the userform. A common choice for users is the proceduce of Workbook_Open() under module ThisWorkbook.
Private Sub Workbook_Open() <user form name>.Show End Sub
Do not use the load method, as this just loads the form but does not make it visible. Besides, Show option automatically loads it anyway.
Load <user form name>