ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disallowing blank cells (https://www.excelbanter.com/excel-programming/327348-re-disallowing-blank-cells.html)

ΊΌΦέΘΛ
disallowing blank cells
 
VBA code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Range("A1") = "" Then MsgBox "Empty Error", vbOKOnly, "Error"
End Sub


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com