Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
Name: Sebastian42
0 
I think the best you could do is use a Worksheet_Change macro to SpellCheck the entire cell you just entered data into.
This will SpellCheck each word in the changed cell after you hit the Enter or Tab key, etc.
Right click the sheet tab, choose View Code and paste this into the pane that opens.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.DisplayAlerts = False
Target.CheckSpelling
Application.DisplayAlerts = False
End Sub
0
DerbyDad03
It works great !
I use it in a collaborative project, but my co-workers think that on balance the 'pros' don't outweigh the 'cons'. It there a way of switching it off until I want to use it again ?Basty
0
What are the cons? I threw it together in a few minutes...there certainly might be room for improvement.
As far as "switching it off" the easiest way would be to right-click the sheet tab, choose View Code and place a single quote at the beginning of the first line.
'Private Sub Worksheet_Change(ByVal Target As Range)
A single quote indicates that the line is a comment, so if you "comment out" the first line, it won't be recognized as a VBA routine.
0
One con is that pressing ENTER or TAB may trigger a dialogue box whose purpose is not clear - as distinct from a dialogue box which suggests a better spelling for a word. It is something I myself am willing to cope with, but others get irritated.
Basty
0
re "...may trigger a dialogue box whose purpose is not clear"
Since I can't see your spreadsheet from here, perhaps you'd be willing to share with me what this dialog box says?
I'm willing to help, but I can't offer advice unless I know specifically what is happening.
0
I do that collaborative work on Thursdays, so next Thursday I will take a screen shot of the box and send it, if before then you can tell me how I can send it, because I do not see any 'attachment' option in this page.
Basty
0
If you can't describe the dialog box via text, upload the screen shot to tinypics.com and then post the resulting URL here.
0
I have no experience with 'uploading', but will try it after I start work on the SS on Thursday.
Basty
0
I have no experience with 'uploading', but will try it after I start work on the SS on Thursday.
I have just looked and found the following boxes Picture Frames
Picture Personal
Personal Pic
Photo Frame
DatingThey only allow SEARCHes - how do I get to 'upload' ?
Basty
0
Sorry, my error.
It's www.tinypic.com not tinypics - no s.
Click Browse to find the file on your system, then click Upload to get the URL.
0
OK - uploading might be a cinch - but how do I get the URL that I need to send to you ?
Basty
0
I uploaded a photo of the recent Chilean volcanic eruption - Chaiten.
I reproduce below the four URLS I was given.
If you tell me which type you want, that is what I'll select on Thursday :HTML for Websites
<a hre "http://tinypic.com" target="_blank">IMG Code for Forums & Message Boards
[IMG]http://i32.tinypic.com/11t0wmh.jpg[/IMG]
URL for E-MaiI & IM
<a href="http://tinypic.com/view.php?pic=11t0wmh&s=3" target="_blank">http://tinypic.com/view.php?pic=11t...
Direct Link for Layouts
http://i32.tinypic.com/11t0wmh.jpgBasty
0
Major 'refurbishment' of the PCs the collaborators use, has meant that I could not do the 'spelling test' today. My upload to tinypic.com will have to wait another week.
Basty
0
There was yet more delay, but today I finally got the chance to try out the macro on the totally revamped system and those 'spurious' querries did not arise at all. So thanks for your efforts.
Do you happen to know about using AutoIt ?
Basty
0  |
 Checkbox - Hide Nonhighli...
|
Outgoing SMTP & Port # fo...
|
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
