You can use Data Validation to ensure "accurate" data entry,
but in order to have something execute when you open the file,
or check for complete entries when exiting the file would require
a VBA "event" macro.
These are macros that run when specific "events" take place, like:
Open
Save
Exit
Change Cell
Change Selection
Print
to ask someone to write a macro like this for free, then maintain it (make
changes as you need them) is quite a bit to ask.
Based on what you've provided, the following macros to meet your requirement:
=============================================================
Private Sub Workbook_Open()
MsgBox "Enter Value in Cell A1"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If (Sheets(1).Range("A1").Value = "") Then
MsgBox "No value entered in cell A1"
Cancel = True
End If
End Sub
=============================================================
But I'm sure your requirement is much more than that.
Paul
-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John
Wesley
-----------------------------------------
From: Dileep Kumar <deepuk...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Thursday, March 5, 2015 4:13 AM
>Subject: $$Excel-Macros$$ Opening & Closing Message for an excel file and Sheet
>
>
>
>Dear Expearts,
>
>
>I have an excel file for which user will enter data, how ever I want to add
>some Opening and Closing messages for the file for alerting users ensuring of
>accurate and complete data entry. Is this can be possible through with out
>using VBA Macro if not please can some one make the required Macro for me.
>
>
>--
>
>Regards,
>Dileep Kumar Kaza
>
--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE : Don't ever post confidential data in a workbook. Forum owners and
>members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google Groups "MS
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
