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

  • Thread starter Thread starter Tdp
  • Start date Start date
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.
 
Placed in the ThisWorkbook sheet:

Private Sub Workbook_Open()
If Sheets("Sheet7").Range("B6").Value = "" Then
UserForm3.Show
End If
End Sub
 
Thanks Luke,
I get the following:
Run Time Error 9
Subscript out of range

any ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
referencing a cell in another worksheet 5
Another code question 3
summarizing data from various workbooks 3
Userform problem 4
Show UserForm if cell is emprty. 6
variable available after userform 2
How to create absolue path link to another workbook (Excel 2003) 1

Back
Top