Interactive User Form Data retreval

[deanblew]

Hello,

I'm trying to learn more VBA and have a problem, proberbly easy but here we go....

I have a interactive user form and when i reun it i can only search for Numbers (see atatched)

I have tried changing the code from IsNumeric to IsText but doesnt work, what am I missing here?

Also for some reason if i enter more than 6 charecters it gives me a error.

Thanks for looking if you do.

D

[BadlySpelledBuoy]

Slightly different approach here. Rather than looping through until you find a match, this just uses FIND to locate the row and recalls the data if found.

Please Login or Register  to view this content.

Any use?

BSB

[deanblew]

I copied the code in and it works great, can't say i totally understand it but it works......

thankyou

[deanblew]

Hi just had a run through and now i get an error when i press the Edit/Add Button.

D

[BadlySpelledBuoy]

Added some comments in green to explain what it's all doing.

Please Login or Register  to view this content.

BSB

[BadlySpelledBuoy]

Hi just had a run through and now i get an error when i press the Edit/Add Button.

Sorry, I didn't look at that bit of code to test for errs.

I have to go out for a while now but will come back to it when I return if nobody else has stepped in.

BSB

[BadlySpelledBuoy]

Add the below to the beginning of the EditAdd sub:

Please Login or Register  to view this content.

BSB