Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
How can I get a UserForm to pop up, when a page is opened, only if a cell is
empty? -- Tdp |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
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" -- Tdp "Bob Phillips" wrote: 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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
You have said Range("a1") but coded Range("B6")
-- __________________________________ HTH Bob "Tdp" wrote in message ... 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" -- Tdp "Bob Phillips" wrote: 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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
Sorry it is "A1". I was multi-tasking at the time!!
-- Tdp "Bob Phillips" wrote: You have said Range("a1") but coded Range("B6") -- __________________________________ HTH Bob "Tdp" wrote in message ... 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" -- Tdp "Bob Phillips" wrote: 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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
Does it now work with A1?
-- __________________________________ HTH Bob "Tdp" wrote in message ... Sorry it is "A1". I was multi-tasking at the time!! -- Tdp "Bob Phillips" wrote: You have said Range("a1") but coded Range("B6") -- __________________________________ HTH Bob "Tdp" wrote in message ... 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" -- Tdp "Bob Phillips" wrote: 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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show UserForm if cell is emprty.
No, I'm afraid not.
-- Tdp "Bob Phillips" wrote: Does it now work with A1? -- __________________________________ HTH Bob "Tdp" wrote in message ... Sorry it is "A1". I was multi-tasking at the time!! -- Tdp "Bob Phillips" wrote: You have said Range("a1") but coded Range("B6") -- __________________________________ HTH Bob "Tdp" wrote in message ... 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" -- Tdp "Bob Phillips" wrote: 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. -- __________________________________ HTH Bob "Tdp" wrote in message ... How can I get a UserForm to pop up, when a page is opened, only if a cell is empty? -- Tdp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform won't show after closing another file | Excel Discussion (Misc queries) | |||
Re-show userform after closing file - code help | Excel Discussion (Misc queries) | |||
Userform won't show when file re-opened | Excel Discussion (Misc queries) | |||
Userform password to show "xxxxxx" in the text box | Excel Discussion (Misc queries) | |||
Properties window show nothing for a userform | Excel Discussion (Misc queries) |