I am using Excel 97.


I have a spreadhsheet with over 1000 rows of data on it and I want a
userform form with textboxes in it which picks up each row of data.

The only thing I have found that might meet my requirements is a function
called 'kickbutt-find function' by Aaron Blood. I don't whether this is what
I want but the first lines of code a

Enum eLookin
xlFormulas = -4123
xlComments = -4144
xlValues = -4163
End Enum

Enum eLookat
xlPart = 2
xlWhole = 1
End Enum

However, My excel doesn't like the Enum part.

Please can anyone assist or point me in the direction of something which
will be ideal for my requirements. I think the form provided in the Data
menu is to basic.

Many thanks

--
Mark