Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing an entry
I swear I've done it before, but I can't remember how.
Can't I force a cell to take a Y or N as opposed to a number (or any other character, for that matter)? Also, can I guarantee that the Y or N is capitolized? Thank you. Chip |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing an entry
Select Data - Validation - List and in the source place Y, N. The default
for the error alert is Stop which will only allow Capial Y or N... -- HTH... Jim Thomlinson " wrote: I swear I've done it before, but I can't remember how. Can't I force a cell to take a Y or N as opposed to a number (or any other character, for that matter)? Also, can I guarantee that the Y or N is capitolized? Thank you. Chip |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing an entry
Jim, thanks for this. I got it to work. This kind of dummy-proofs the
cell so that only a capitol Y or N can be used, especially when I use the Input Message or Error Alert. Let's assume that the range D1:D100 clearly needed a Y or N. No other option would make sense to the user. If a user enters a lower case y, is there a way that once he hits enter it gets changed to a capitol letter? I know I can use =UPPER(D1:D100), but that only works in a different column. Chip Jim Thomlinson wrote: Select Data - Validation - List and in the source place Y, N. The default for the error alert is Stop which will only allow Capial Y or N... -- HTH... Jim Thomlinson " wrote: I swear I've done it before, but I can't remember how. Can't I force a cell to take a Y or N as opposed to a number (or any other character, for that matter)? Also, can I guarantee that the Y or N is capitolized? Thank you. Chip |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing an entry
If you are using a DV dropdown box on every cell there would be no need for any
change because the user is seleting from the DV dropdown. If the range D1:D100 "clearly" makes sense that a Y or N is to be entered you could use event code. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Me.Range("D1:D100")) Is Nothing Then On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) End If ErrHandler: Application.EnableEvents = True End Sub This is sheet event code. Right-click on the sheet tab and copy/paste into that module. ALT + q to go back to your worksheet Type in a lower case "y" and will become upper case. Gord Dibben MS Excel MVP On 19 Oct 2006 13:36:48 -0700, " wrote: Jim, thanks for this. I got it to work. This kind of dummy-proofs the cell so that only a capitol Y or N can be used, especially when I use the Input Message or Error Alert. Let's assume that the range D1:D100 clearly needed a Y or N. No other option would make sense to the user. If a user enters a lower case y, is there a way that once he hits enter it gets changed to a capitol letter? I know I can use =UPPER(D1:D100), but that only works in a different column. Chip Jim Thomlinson wrote: Select Data - Validation - List and in the source place Y, N. The default for the error alert is Stop which will only allow Capial Y or N... -- HTH... Jim Thomlinson " wrote: I swear I've done it before, but I can't remember how. Can't I force a cell to take a Y or N as opposed to a number (or any other character, for that matter)? Also, can I guarantee that the Y or N is capitolized? Thank you. Chip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
Checking & Forcing Data Entry in Cells | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Forcing Combo box entry in VBA | Excel Discussion (Misc queries) |