HELP-Dictionary

Greetings,

I need some help with excell. I have an access database that serves as a dictionary. There are two colums, one serving as the terms and the second serving as the definitions. By creating a form in Acess I was able to make the term coloum serachable. When the word was found that I wanted, I could press enter and the definition in the corresponding colum would appear.

I am trying to get this same effect in excel, yet I am not sure how to do it. Someone mentioned using pivit tables and forms.

I would apreciate any help I can get.

Thanks,
Dan

A simple form with a textbox for the word, and a (larger) textbox for the
definition, with a Search button.

Assuming that the data is all in a worksheet called Words, with the words in
column A, and the definitions in column B, the code for the button would be

Private Sub cmdSearch_Click()
Dim iPos As Long

With Textbox1
If .Text <> "" Then
iPos =
Application.Match(.Text,Worksheets("Words").Range("A:A"),0)
If iPos = 0 Then
Textbox2.Text = "Word not found"
Else
Textbox2.Text =
Application.Index(Worksheets("Words").Range("A:A"),iPos)
End If
End If
End With
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dfisch8" <dfisch8.1u6dul_1124730477.1075@excelforum-nospam.com> wrote in
message news:dfisch8.1u6dul_1124730477.1075@excelforum-nospam.com...
>
> Greetings,
>
> I need some help with excell. I have an access database that serves as
> a dictionary. There are two colums, one serving as the terms and the
> second serving as the definitions. By creating a form in Acess I was
> able to make the term coloum serachable. When the word was found that I
> wanted, I could press enter and the definition in the corresponding
> colum would appear.
>
> I am trying to get this same effect in excel, yet I am not sure how to
> do it. Someone mentioned using pivit tables and forms.
>
> I would apreciate any help I can get.
>
> Thanks,
> Dan
>
>
> --
> dfisch8
> ------------------------------------------------------------------------
> dfisch8's Profile:
http://www.excelforum.com/member.php...o&userid=26515
> View this thread: http://www.excelforum.com/showthread...hreadid=397822
>

greetings,

thanks for the prompt reply. I seem to be having issues getting this code to work, could you provide me with your e-mail and I can send you my spreadsheet? If you could input it for me I would apreciate it.

thanks,
dan

bob dot phillips at tiscali dot co dot uk

do the obvious

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dfisch8" <dfisch8.1u6jfu_1124738111.3331@excelforum-nospam.com> wrote in
message news:dfisch8.1u6jfu_1124738111.3331@excelforum-nospam.com...
>
> greetings,
>
> thanks for the prompt reply. I seem to be having issues getting this
> code to work, could you provide me with your e-mail and I can send you
> my spreadsheet? If you could input it for me I would apreciate it.
>
> thanks,
> dan
>
>
> --
> dfisch8
> ------------------------------------------------------------------------
> dfisch8's Profile:
http://www.excelforum.com/member.php...o&userid=26515
> View this thread: http://www.excelforum.com/showthread...hreadid=397822
>