VBA If statement for User Form

[Sandsawks]

Okay so I assume that an If statement would be the best for what i need but if you have another type of code that will be fine.

Situation: I have a work sheet that as of right now i have a User form that opens when the worksheet is opened. The user form you place data in is copied to its respective cells when closed then my clients can request material and save the form and email it to my supervisor for processing. The thing is when my supervisor opens the form i dont want that user form to pop up since the clients already entered the data. He isnt exactly computer savy so i feel it will be a nusiance for him to have to cancel the user form every time. So can anyone help with a code that will basically say when i open this sheet display user form "HeaderInfo" If cell A5 is blank, and if the cell contains data do not display the user form.

Thank you in advance!

 

[Andrew Poulsom]

Like this?

Private Sub Workbook_Open()
    If Worksheets("Sheet1").Range("A5").Value = "" Then
        HeaderInfo.Show
    End If
End Sub

 

[Sandsawks]

Thank you, it works perfect!