Help Searching a database to find text that was input

**jchapm123** · 09-24-2010, 02:43 PM

Hello,
I am new to the VBA/Macros world and I find it very interesting. I am trying to create a macros that simply calculates vapor pressure of a given amount of solvents. I have already created the database but now what I want to do is ask the user to input the "name or chemical formula" of the solvent and them my macros will look in the database, find the solvent, and with the information in the database and the input temperature, calculate the pressure. I do not know how to get it to search my entire database (2 columns) to match the input.

Thanks for your help,
Jeremiah

**StephenR** · 09-24-2010, 03:00 PM

Perhaps you could attach a sample workbook?

**jchapm123** · 09-26-2010, 02:06 PM

Well I think I figured something out but now I am trying to sum the pressure variables outside of the loop.

Please Login or Register  to view this content.

**StephenR** · 09-28-2010, 01:29 PM

It's a bit hard to work out what you're doing from some code.

**royUK** · 09-28-2010, 01:59 PM

Your find looks for the input, activates the cell then promptly looks for " ." which nullifies the first search.

Without understanding what you are doing or seeing an example my suggestion would be that you don't need VBA, but a VLOOKUP formula & an equation