Thread: searching data using a userform

Does this do the trick?

I guess I ought to provide some instructions:

To open the form go to Tools > Macro > Macros > "DoForm"

The first button is a "read" button - it looks up the invoice number corresponding to the barcode number, and puts it into the second text box.

The second button is a "write" button - it takes whatever's in the second text box and writes it into the data.

I haven't made it very error proof, secure or intuitive but after all, I'm not getting paid.

Originally Posted by Ancalagon12321

I guess I ought to provide some instructions:

To open the form go to Tools > Macro > Macros > "DoForm"

The first button is a "read" button - it looks up the invoice number corresponding to the barcode number, and puts it into the second text box.

The second button is a "write" button - it takes whatever's in the second text box and writes it into the data.

I haven't made it very error proof, secure or intuitive but after all, I'm not getting paid.

Hi Ancalagon,

Thanks for that, its a start; just dicovered that all the numbers in green have formulas not values in,so it does not work unless i change cells to numeric values.

I did organize this sheet, will need a bit of re-thinking.

cheers for what you did

stephen

Stephen: Find the line of code that uses "Find" and change it from this:

Code:

something.Find(something)

to this:

Code:

something.Find(something, LookIn:=xlValues)