T
Tdp
How can I get a UserForm to pop up, when a page is opened, only if a cell is
empty?
empty?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Private Sub Worksheet_Activate()
If Range("A1").Value = "" Then UserForm1.Show
End Sub
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
If Range("A1").Value = "" Then UserForm1.Show
End Sub
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
T
Tdp
Thanks for that.
I'v tried modifying your code so that when the workbook opens to sheet1
everytime. Userform1 to show if Range("a1") in Sheet7 is empty, but with no
luck!!!
I'm using the following:
Private Sub Workbook_Open()
If Sheet7.Range("B6").Value = "" Then UserForm3.Show
End Sub
I'v placed this code in "ThisWorkbook"
I'v tried modifying your code so that when the workbook opens to sheet1
everytime. Userform1 to show if Range("a1") in Sheet7 is empty, but with no
luck!!!
I'm using the following:
Private Sub Workbook_Open()
If Sheet7.Range("B6").Value = "" Then UserForm3.Show
End Sub
I'v placed this code in "ThisWorkbook"
B
Bob Phillips
You have said Range("a1") but coded Range("B6")
T
Tdp
Sorry it is "A1". I was multi-tasking at the time!!
B
Bob Phillips
Does it now work with A1?
T
Tdp
No, I'm afraid not.
--
Tdp
--
Tdp
Bob Phillips said:Does it now work with A1?
--
__________________________________
HTH
Bob