i am saving data to a database in another workbook... wb2 as an example and im searching details from another workbook wb1.. now im using a user form that opens the wb2 and finds the referrance number.

i can seem to get the find result to show on my userform say in lbl1.

any ideas??

im thinkin of something like this.

(i have already opened wb2 and txtCri is the search value)

fnd = range("A:A").Find(What:= txtCri.Value, LookAt:= xlWhole).Row

'now what could i put??
'i did have:

frm1.lbl1.caption = range("A" & fnd)

but it then thinks that frm1 is in wb2 when its in wb1 any help i wud be greatful.