How can I make a cell mandatory and only accept a Y or N?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make a cell mandatory, but in the event that I can't do that
I would still like to be able to only have a choice of Y or N.
 
I would like to make a cell mandatory, but in the event that I can't do that
I would still like to be able to only have a choice of Y or N.
Click to expand...

You could use an event macro to do both.

You may want to specify a particular worksheet if your workbook has multiple
sheets, though.

To enter this code, right click on the sheet tab and select View Code. Then
paste the code below into the window that opens.

Change the "c" reference to the appropriate cell.

Note that, as written, Y or N must be entered in upper case. Obviously this
can be changed if such is not your intent.

======================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range

Set c = Range("A1")

Application.EnableEvents = False

If c.Text <> "Y" And c.Text <> "N" Then
Application.Goto reference:=c, scroll:=True
MsgBox ("Must Enter ""Y"" or ""N"" in A1")
End If

Application.EnableEvents = True
End Sub
========================
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Scrabble Value calculation for Welsh words 0
Excel Making a cell Mandatory 9
How do you restrict a cell to accepting only "Y" or "N" ? 2
Making Cells Mandatory and Running Checks 3
stop a clicked on cell being left blank 2
how to make a cell mandatory in the excel sheet 2
calculate tax based on y or N 3

Back
Top