ok everyone sorry I have another problem so soon but I have been wrestling with this one all day.

used find macro
found cell
made active
need the into in active cell to appear in textbox1 on a userform1 that appears automatically when the find macro finds the value

the book i am using says I can use properties but i think he is using a different version because he has different properties I am using Excell 2000

any help?

nevermind everyone I figured it out.

What was your solution?

set what you want to be in the text box as active then use

textbox1 = range(Activecell.column & Activecell.row)