Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)
hello evryone
File > Option > Proofing
I Added this word AAG (replace) = AHSAAN G (with)
This mean when i type in any cell AAG then the result = AHSAAN G
Now if i type aag (lower case) then no auto correction works
then
i use a code to change lower case to upper case
now if i type aag (lower case) then result = AAG
NOT AHSAAN G
ANY SOLUTION
PLZ
Last edited by HaroonSid; 03-26-2014 at 11:50 PM. Reason: solved
Hi - in the spellcheck dialog there is an autocorrect button which will update any entries entered by code. I don't think you can trigger this by code though.
Is that the only string you want to replace with something else? If so, you can use this code. This must be placed in the module where the data will be entered (e.g., Sheet1). It will replace only if "AAG" is the entire cell content, that is, it will not change "ZZZ AAG ZZZ".
Please Login or Register to view this content.
Hello F-MOD : 6StringJazzer
u solved my big problem
thanx a lot
hello ragulduy
In Auto correction mode i create entries in Upper case
but when i type entries in small case then auto correct doesn't work
b t w thanx a lot for reply
F-MOD : 6StringJazzer solved my problem
thanx once again
best regards
haroon2015
@haroon - sorry, I thought you meant when you made an entry by code that the autocorrect doesn't work. I meant you can then use the spellcheck/autocorrect button to apply the autocorrect rules to all the existing cells on the spreadsheet (like the ones entered by code).
If you just want to change lower case aag to AHSAAN G then a better solution would be to add two autocorrect rules:
Replace AAG with AHSAAN G
and
REPLACE aag with AHSAAN G
hello
ragulduy
thanx for info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks