Consulting

Results 1 to 2 of 2

Thread: dictionary userform

  1. #1
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location

    dictionary userform

    hello
    i want to use a collins online dictionary & thesaurus.the following code should enable the user through a textbox enter a word and then select whether dto use a dictionary or a thesaurus.
    [VBA]
    Private Sub CommandButton1_Click()
    UserForm19.hide
    TextBox1.Value = ""
    End Sub
    Private Sub CommandButton2_Click()
    Dim link
    link = "http://www.collinslanguage.com/wordl...textbox1.value"
    On Error GoTo NoCanDo
    ActiveWorkbook.FollowHyperlink Address:=link, NewWindow:=True
    Unload Me
    Exit Sub
    NoCanDo:
    MsgBox "Cannot open " & link
    End Sub
    Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    Cancel = True
    End Sub

    [/VBA]
    how do i use checkbox select the right internt page?
    thanks
    moshe
    moshe

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Try:
    [VBA]http://www.collinslanguage.com/wordlist.aspx?startingwith=" & textbox1.value[/VBA]

Posting Permissions

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