try an input box

Set MyRange = Application.InputBox("Select Record", Type:=8)
MyRow = MyRange.Row
Sheets("Sheet1").Range("A1") = Sheets("Sheet2").Range("A" & MyRow)


"Ixtreme" wrote:

Thanks but I want something like an option to select which record to
be displayed. Something like a form that ask you: which record do you
want to retrieve? Enter record number. Then if the user selects a
record, it will fetch up the details from that record from sheet2 and
displays it in the original sheet1.
Is that possible?