Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default How to invoke spellchecker in VBA to check a string?

I want to create pnemonic strings to help remember telephone numbers. I set
up a program that will run through every possible character combination of
the 3 letters on numbers 2-9 and return every possible 7-character string
(about 2200 total for each 7-digit phone number), but of course most of what
it returns is gibberish.

How can I invoke the spellchecker (as used within Excel) but send it my
strings, and reject any 7-letter string that isn't recognized in the
spellchecker dictionary? That way I can only populate my worksheet with the
strings that might make (better) pnemonics.

Code snippets greatly appreciated!

Many Thanks,
Keith


--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default How to invoke spellchecker in VBA to check a string?

Keith

Try here for an example

http://www.dicks-blog.com/excel/2004...ering_tel.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"KR" wrote in message
...
I want to create pnemonic strings to help remember telephone numbers. I

set
up a program that will run through every possible character combination of
the 3 letters on numbers 2-9 and return every possible 7-character string
(about 2200 total for each 7-digit phone number), but of course most of

what
it returns is gibberish.

How can I invoke the spellchecker (as used within Excel) but send it my
strings, and reject any 7-letter string that isn't recognized in the
spellchecker dictionary? That way I can only populate my worksheet with

the
strings that might make (better) pnemonics.

Code snippets greatly appreciated!

Many Thanks,
Keith


--
The enclosed questions or comments are entirely mine and don't represent

the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check for case of string msnyc07 Excel Worksheet Functions 3 February 18th 10 12:11 AM
Check for NON-presence of a string in another string G.P.N.L. c.v.a. Excel Worksheet Functions 4 December 11th 09 06:10 PM
Check if variable contains a string Ted M H Excel Worksheet Functions 5 December 22nd 08 03:58 PM
ActiveXTextBox with SpellChecker ? Stuart[_5_] Excel Programming 0 July 23rd 04 08:38 PM
Using Excel Spellchecker On a Locked sheet Doug Lansing Excel Programming 1 September 27th 03 03:06 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"