Hey do any of you guys know how to do searches in an excel file from a VBA form using OLE? What exactly I want to do is below...
When a value is entered in a text box and a button is clicked, I want the program to go off and search through a column in an excel file to find the word input. It should then know it is in column (1, i) [if "i" is the one across, I can never remember] then I want it to add 1 to (2, i).
How would I do this in VBA?? Please help. I can do the adding if I know the cell number, but it has to be found first and I don't know how to do this.
Thanks in advance.
Bean
