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

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.
--
Tdp

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

Placed in the ThisWorkbook sheet:

Private Sub Workbook_Open()
If Sheets("Sheet7").Range("B6").Value = "" Then
UserForm3.Show
End If
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tdp" wrote:

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.
--
Tdp

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

Thanks Luke,
I get the following:
Run Time Error 9
Subscript out of range

any ideas?
--
Tdp


"Luke M" wrote:

Placed in the ThisWorkbook sheet:

Private Sub Workbook_Open()
If Sheets("Sheet7").Range("B6").Value = "" Then
UserForm3.Show
End If
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tdp" wrote:

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.
--
Tdp