Reposted question: If cell is empty show userform????????

T

Tdp

If cell "B6" in sheet7 value = "" then show userform3.
How do I put that in code when the workbook is opened.
This workbook always opens on sheet1.
Thank you.
 
L

Luke M

Placed in the ThisWorkbook sheet:

Private Sub Workbook_Open()
If Sheets("Sheet7").Range("B6").Value = "" Then
UserForm3.Show
End If
End Sub
 
Top