| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show UserForm if cell is emprty. | Excel Discussion (Misc queries) | |||
| Show day or empty cell | Excel Discussion (Misc queries) | |||
| Show cell empty when 0 | Excel Discussion (Misc queries) | |||
| Lookup to Show Empty Cell | Excel Worksheet Functions | |||
| Question Reposted | Excel Worksheet Functions | |||
Linear Mode
