Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Thanked 0 Times in 0 Posts

    excel dictionaries

    I'm on a Win98 Office97 Excel and need to know how to get the portuguese dictionary I use in Word to operate in Excel? Does anyone know how to get this access so I do not have to copy cells to Word and spellcheck them and then copy back to my spreadsheet... It would be great to know how! Thanks and greetings from Mozambique

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Kortrijk, Belgium
    Thanked 0 Times in 0 Posts

    Re: excel dictionaries

    As far as I know, for Office 97, you can set the language from Word and this will also apply to Excel.
    For Office 2000, you can use the "Microsoft office language settings" program provided with the Office 2000 language Packs.

    Try the following macro to know your language settings in excel:

    Sub LanguageSettings()
    Dim Msg As String
    Dim CountryCode As Integer
    Dim StCs As String
    'the language version of excel or of the currently active office language
    CountryCode = Application.International(xlCountryCode) & vbCrLf
    Select Case CountryCode
    Case 1
    StCs = "US"
    Case 31
    StCs = "The Netherlands"
    Case 32
    StCs = "Belgium"
    Case 33
    StCs = "France"
    Case 44
    StCs = "UK"
    Case 47
    StCs = "Norway"
    Case 351
    StCs = "Portugal"
    End Select
    MsgBox "Excel Language = " & StCs
    End Sub

    The numbers should follow the country codes used by the telephone system.

    Hope this helps.

Posting Permissions

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