This is an very big question to answer so I am just goint to summarize
what you want to do.

You don't need a user form at all. From the sound of it, you should
put code you wish to execute when the workbook is opened in the
Workbook_Open event (in the ThisWorkbook object). I would create a
command bar and a command button (look these up in the object explorer
for help) in this open event. Set the "onaction" property of the
command button to call your routine:

Private Sub dagensDatumKnapp_Click()
findAndRemoveBlanks
findQC
findMV
findDate
End Sub

Hope this helps point you in the right direction.
-K