form that copy the listbox from other sheet

Hi,

This code is working great but the problem is i want to have a data from other sheet. and when i use the code below, it's giving me error.

Please Login or Register  to view this content.

in my sheet 2 where is my commandbutton belong. The attached file is the modified and the other one is the original. Thanks!

ahhhh,, I see. Thanks!!!!! I'll try it!

---------- Post added at 04:50 AM ---------- Previous post was at 04:43 AM ----------

hi,
it looks like it's not looking from sheet1. The data is in Sheet1 not Sheet2, only the button is in the sheet2. I want the data from my sheet1 and i can search thru data even i'm in the sheet2 (co'z my cmdbutton is in sheet2). Is there anyway we can achieve this?

Thanks!

I tried your code, but i need the whole word to be searched and use multicolumn. In my modified excel(searchandcopy.xls) i use another button to copy to clipboard. and that's what i need.

it worked! Thanks!