i'm still not understanding to well...let me explain with a little mor
detail about what I'm trying to do...

on sheet("06") I have order numbers in column A, in column B, I hav
the names of the people whose order numbers are in column A. Ever
worksheet in the workbook is like this(except for sheets that i'v
named "Top" and "Bottom". Every inserted worksheet goes in betwee
those 2 worksheets). as of right now, I have it so that if I type i
someone's order number in textbox1, then the corresponding name show
up in label1 on the UserForm. However, I don't know how to make my cod
look at more than than just "06", I want it to look at all the sheet
in the workbook, or at least the sheets in between "Top" and "Bottom"
as well as 2 other workbooks in the same format

--
Message posted from http://www.ExcelForum.com