<div>
<div class="content wysiwyg-content">
I have a working Excel 365 spreadsheet, type xlsm, that I need to add a cell to. &nbsp;This spreadsheet is used for entry purposes and incorporates much VB for applications. &nbsp;I need to add a field that will be limited to field values of 'Y' or 'N' and will provide an error message when an invalid value is entered. &nbsp;This is basic using the Data Validation button in Excel. &nbsp;My problem arises since I need this field to have an INITIAL value of blank or space. &nbsp;I do initialize the field in the VB code upon opening the spreadsheet to a value of &quot;&nbsp;&quot;. &nbsp;This also works yet once the spreadsheet is opened, it does not force the user to enter either a 'Y' or 'N' in the field. &nbsp;It will only give an error message if another value is entered into the field. &nbsp;So, it can be printed or saved with a blank in the field even though it restricts ENTRY to 'Y' or 'N'. &nbsp;Does anybody know a way around this. &nbsp;So I can have the spreadsheet open up with no value in the field but still force them to enter a 'Y' or 'N' before printing or saving? &nbsp;Thank you very much!
</div>
</div>


I have a working Excel 365 spreadsheet, type xlsm, that I need to add a cell to.  This spreadsheet is used for entry purposes and incorporates much VB for applications.  I need to add a field that will be limited to field values of 'Y' or 'N' and will provide an error message when an invalid value is entered.  This is basic using the Data Validation button in Excel.  My problem arises since I need this field to have an INITIAL value of blank or space.  I do initialize the field in the VB code upon opening the spreadsheet to a value of " ".  This also works yet once the spreadsheet is opened, it does not force the user to enter either a 'Y' or 'N' in the field.  It will only give an error message if another value is entered into the field.  So, it can be printed or saved with a blank in the field even though it restricts ENTRY to 'Y' or 'N'.  Does anybody know a way around this.  So I can have the spreadsheet open up with no value in the field but still force them to enter a 'Y' or 'N' before printing or saving?  Thank you very much!

Excel 365 cell needs initial value of blank, but can only have a value of 'Y' or 'N'.

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.