$$Excel-Macros$$ VBA to Check Spelling and Highlight Individual Words
Dear Sir / Madam
I have an Excel sheet with VBA which is designed to compare two boxes
of text/copy and highlight any differences. The existing code is very
good although, it does not currently highlight individual words (it
only changes the box color to red to suggest there is an error).
Here is the existing code (the spreadsheet can also be shared if that
would be useful?):
'check the spelling of the selected text
Select Case bcheck
Case True
If SpellingIsCorrect(sCopy) = False Then
If .Range("Q" & plRow).Value = "" Then
.Range("Q" & plRow).Value = "Check ASF
spelling"
Else
.Range("Q" & plRow).Value = .Range("Q" &
plRow).Value & " | Check ASF spelling"
End If
End If
If SpellingIsCorrect(sEmail) = False Then
If .Range("Q" & plRow).Value = "" Then
.Range("Q" & plRow).Value = "Check email
spelling"
Else
.Range("Q" & plRow).Value = .Range("Q" &
plRow).Value & " | Check email spelling"
End If
.Range("J" & plRow).Select 'background = red as
this is an error
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent2
.TintAndShade = 0.399945066682943
.PatternTintAndShade = 0
End With
End If
Case Else
'do nothing as we do not want to check the spelling in
anything but the above sections
End Select
Is it possible to adapt the code so that individual (incorrectly
spelt) words are highlighted (rather than the whole block)?
Any help much appreciated,
Kind regards
Greg
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Finding specific text and returning nearby data (from another column)
Hi I'm trying to work out how I can automate (macro or formula) finding specific data in a xls and returning the data in a nearby column. More sepcifically, all the worksheets I'm using include a revenue total and by this total there is always the text 'ex VAT' (this always only appears once on a worksheet). I'd like to find 'ex Vat' and return the total revenue in the column 2 to the right and group these together on a summary sheet. My attempt is: =IF(A1:F100="ex vat",2,0)* * = is the area where the data can be found (could it be the entire worksheet?) Can anyone suggest a formula? Thanks in advance Greg -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Adding rows and tab names depending on a specific cell contents
Hi I need the following tasks to be automated whenever an additional tab is opened and data pasted into an Excel 2007 worksheet; 1) Look at a specific cell in the added sheet and dependant on its contents, add an additional row to one of three sections of a summary sheet (e.g. if cell = "house" then add a row under the 'house' heading on summary sheet, between rows 10 and 20, if cell = "flat" then add row under 'flat' heading on summary sheet, between rows 30 and 40) 2) Add the text from a specific cell in the added sheet into the new row on the summary sheet (1). 3) Look at the same specific cell (as 2) and dependant on its contents, concatonate with other data and name the tab of the sheet (e.g. if cell = "house" then concatonate with default text "WR" and another cell e.g "mansion" - so creating the tab name - "WR_mansion_house") I assume this would have be done via a Macro/VBA? Any help with this, much appreciated. Greg -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)
Thanks Dilip - I've uploaded the file 'sample.xlsx' Regards, Greg On 9 Sep, 15:52, Dilip Pandey wrote: > Hi Greg, > > Please share a sample file with the Group. Thanks > > Best Regards, > DILIPandey > > On 9/9/10, gdbar...@googlemail.com wrote: > > > > > Hi > > > I'm trying to work out how I can automate (macro or formula) finding > > specific data in a xls and returning the data in a nearby column. > > > More sepcifically, all the worksheets I'm using include a revenue > > total and by this total there is always the text 'ex VAT' (this always > > only appears once on a worksheet). I'd like to find 'ex Vat' and > > return the total revenue in the column 2 to the right and group these > > together on a summary sheet. My attempt is: =IF(A1:F100="ex vat",2,0)* > > > * = is the area where the data can be found (could it be the entire > > worksheet?) > > > Can anyone suggest a formula? > > > Thanks in advance > > > Greg > > > -- > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)
Hi Dilip Thanks so much for the workbook - it's great. I have some more work to do on the project. So I may need your help again in the future?! Do you think it is best to re-submit to this post? Or start a new thread? Thanks again. Greg On 11 Sep, 16:26, Dilip Pandey wrote: > Hi Greg, > > Please find the attached workbook and let me know if this solves your purpose > :) > > Best Regards, > DILIPandey > > On 9/9/10, gdbar...@googlemail.com wrote: > > > > > Thanks Dilip - I've uploaded the file 'sample.xlsx' > > > Regards, Greg > > > On 9 Sep, 15:52, Dilip Pandey wrote: > >> Hi Greg, > > >> Please share a sample file with the Group. Thanks > > >> Best Regards, > >> DILIPandey > > >> On 9/9/10, gdbar...@googlemail.com wrote: > > >> > Hi > > >> > I'm trying to work out how I can automate (macro or formula) finding > >> > specific data in a xls and returning the data in a nearby column. > > >> > More sepcifically, all the worksheets I'm using include a revenue > >> > total and by this total there is always the text 'ex VAT' (this always > >> > only appears once on a worksheet). I'd like to find 'ex Vat' and > >> > return the total revenue in the column 2 to the right and group these > >> > together on a summary sheet. My attempt is: =IF(A1:F100="ex vat",2,0)* > > >> > * = is the area where the data can be found (could it be the entire > >> > worksheet?) > > >> > Can anyone suggest a formula? > > >> > Thanks in advance > > >> > Greg > > >> > -- > >> > -- > >> > Some important links for excel users: > >> > 1. Follow us on TWITTER for tips tricks and links : > >> >http://twitter.com/exceldailytip > >> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> > To post to this group, send email to excel-macros@googlegroups.com > > >> > <><><><><><><><><><><><><><><><><><><><><><> > >> > HELP US GROW !! > > >> > We reach over 7000 subscribers worldwide and receive many nice notes > >> > about > >> > the learning and support from the group.Let friends and co-workers know > >> > they > >> > can subscribe to group at > >> >http://groups.google.com/group/excel-macros/subscribe > > >> -- > >> Thanks & Regards, > > >> DILIP KUMAR PANDEY > >> MBA-HR,B.Com(Hons),BCA > >> Mobile: +91 9810929744 > >> dilipan...@gmail.com > >> dilipan...@yahoo.com > >> New Delhi - 62, India > > > -- > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > Sample.xlsm > 48KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
