Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
force english excel
Name: mherber2 Date: October 10, 2007 at 07:50:34 Pacific OS: xp CPU/Ram: unknow Product: not important
Comment:
ok what im looking to do is some how either block a language or allow only certian languages in excel. is there an option for this or can it be done in vb or can it be done at all????
Name: DerbyDad03 Date: October 10, 2007 at 09:10:49 Pacific
Reply:
The only way I can think of doing it would be to SpellCheck each entry with an English SpellChecker as soon as it was entered. You could then delete the contents and/or present a MsgBox to the user.
However, certain words, like adios and jour are not flagged as misspelled words. It's also going to catch English misspellings upon entry, so your MsgBox might have to be customized to fit.
Right Click the sheet tab, chose View Code and paste this in. Then enter some non-English words in any cell.
Private Sub Worksheet_Change(ByVal Target As Range) If Application.CheckSpelling(Target) <> True Then MsgBox "Non-English Languages Not Allowed" Target = "" End If End Sub
0
Response Number 2
Name: mherber2 Date: October 10, 2007 at 13:41:53 Pacific
Summary: I am trying to code a carriage return within an excel cell using vbscript. When I append chr(10) or Chr(10) & Chr(13) to the string that is being written in the cell, it begins a new row in the excel ...
Summary: Hi again. I have a user that is coping and pasting text from Excel to a proprietery program that doesn't support certain foriegn language fonts (in this case Slovinian). I there for set up thro Contro...
Summary: Hi, I need a help. I hope my english is good enough, I don't know the exact english words used to describe Microsoft Excel features... I'd like to know if there is a way to sum colored cells. I mean: ...
0 
