active x to search cells

[chirs73]

I am trying to use active x to search a column of cells in an excel spreadsheet to see if a value is already in the spreadsheet. Any help is greatly appreciated.

Thanks

Chirs

[smercurio_fc]

A search can usually turn up results. Did you try?

search

[chirs73]

I tried a search but don't think i put in the correct search terms. Thanks for your help

chirs

[smercurio_fc]

---

chirs73 wrote:

I tried a search but don't think i put in the correct search terms.

---

That's always the hardest part.   Sometimes I wish search engines could read our minds rather than read what we type. 

[chirs73]

I have looked through everything up here and I found most of my answer. The one thing I need to do and I don't see it here is If the value I'm searching for is found I need to have a message popup and let the user know that there is a problem. Is there something I have overlooked?

Chirs

[smercurio_fc]

The result of the search should return a cell or range reference if I remember correctly. If this reference is null then the find did not return anything.If you're still having problem just post your code and we can look at it.

Message Edited by smercurio_fc on 11-05-2008 03:26 PM

[Joe_H]

Have a look here at this thread were I posted some VI's that should do what you want. Look for replace.llb

For more information and some sample VI's and tool kits, you can go to the excel board

[chirs73]

Are there any books that explain all of the possible coding that can be done with Active X?

Chirs

[smercurio_fc]

I'm assuming you're referring to using ActiveX with Excel specifically, as using ActiveX is a fairly broad topic. Excel's ActiveX interface is fully documented in MSDN. There are also lots of sites with example VBA code to automate Excel. Here's one. Here's another.

[chirs73]

I have this approximately 98% completed. The only thing I can't find is how to increment the cell that I am searching. I want to start my search in cell A5, retrieve the data in that cell. On the next iteration I need cell A6 to be read. Anybody ever have this issue? Any help is greatly appreciated.

Thanks

Chirs