• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mandatory Field

You can try this vb code..


Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Worksheets("Sheet1").Range("A1").Value = "" Then

MsgBox "You must fill value in Sheet1 A1."

Cancel = True

End If

End Sub


The workbook won't close if cell A1 at Sheet1 is empty.
 
on maneu bar go data > data validation > data validation than there are some options which you can use.
 
Hi, jigar_metha!

If solutions suggested by aamirsq or Muhammad Shakeel and regarding your not so polite last answer, why don't you please elaborate a bit more your requirements and upload a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you.

Give a look at the green sticky posts at this forums main page for uploading guidelines.

Regards!
 
I does not meen that way,

I just wanted to indicate that conditional formating is not catering the required logic for the same,

I regreat,
 
Dear jigar_mehta

You can apply the logic.

>Data validation

>Select Text length from Allow

>Select Greater than from Data

>Type 0 in Minimum>OK


Regards,

Muneer
 
You must log in or register to reply here.
Back
Top