+ Reply to Thread
Results 1 to 7 of 7

English Dictionary in Excel

  1. 08-27-2017, 03:19 PM #1
    danielexcelvba
    danielexcelvba is offline
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    English Dictionary in Excel

    Hey everyone,

    This technically isn't a problem but I couldn't find anything in the Forum Rules that says it isn't allowed. I'm working on coding a two player Scrabble game in Excel. One of the features of the game is validating that the word entered is in fact an English word, and so far I've been managing this by entering any word that comes up into a makeshift dictionary on an unused sheet. I was wondering if anyone has an English dictionary in an Excel doc that they wouldn't mind sharing as that would save me a lot of time.

    Thanks in advance!

    Edit: I now realize I posted this in the VBA forum and that doesn't make sense but I can't move it now
    Last edited by danielexcelvba; 08-27-2017 at 03:25 PM.
    Reply With QuoteRegister To Reply
  2. 08-27-2017, 03:31 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: English Dictionary in Excel

    Google
    keywords: english dictionary excel format free download
    first shot
    Reply With QuoteRegister To Reply
  3. 08-27-2017, 03:39 PM #3
    protonLeah
    protonLeah is online now
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,629

    Re: English Dictionary in Excel 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  4. 08-27-2017, 04:14 PM #4
    danielexcelvba
    danielexcelvba is offline
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: English Dictionary in Excel

    @sandy thanks I may go that route I just didn't see anything that looked like a reliable source

    @Leah that's a really cool workaround and would actually speed this up quite a bit. I tried the code and it works for me when I test it on a word in a cell, but it isn't working for me when I try to input a string variable (i.e. Application.CheckSpelling(VariableName)). Is there any reason this shouldn't work, or am I just doing something wrong? Thanks
    Reply With QuoteRegister To Reply
  5. 08-27-2017, 04:18 PM #5
    danielexcelvba
    danielexcelvba is offline
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: English Dictionary in Excel

    Never mind I figured that part out. Just had to set IgnoreUppercase = False as my variable was storing strings with all capital letters. Thanks again!
    Reply With QuoteRegister To Reply
  6. 08-27-2017, 04:21 PM #6
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,912

    Re: English Dictionary in Excel

    Found one here.

    http://www.bragitoff.com/2016/03/eng...in-csv-format/

    Afterwards just have to open csv file, use textToColumns to seperate Column A and SaveAs xlsx
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
  7. 08-27-2017, 04:33 PM #7
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: English Dictionary in Excel

    Just exactly what bakerman2 said - it was the first shot from google with my keywords.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2016, 08:28 AM
  2. Storing a Dictionary into a Dictionary Object
    By pago_boss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 03:04 AM
  3. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 PM
  4. list of 100,000 English words- is there a way to access Micrsoft's dictionary ex below.
    By azhar.sayed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 12:57 AM
  5. English to English Dictionary in MS Excel format
    By waqaszhr in forum Excel General
    Replies: 0
    Last Post: 12-03-2012, 03:19 PM
  6. Dictionary Object in Excel?
    By danny2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2009, 02:20 AM
  7. Write English Formulas in non-english Excel
    By ChrisNor in forum Excel General
    Replies: 5
    Last Post: 03-09-2009, 08:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1