Excel confused with Gap or bad programming?

[margal]

Hi everyone, I'm a bit new to programming and just wonder if I'm confused with my programme below.

The idea is when the button is pressed, the user should enter an invoice no, the programme should then check to see if that invoice is on the system and warn the user based on the outcome.

However this is the issue I find, so lets say the invoice was SPR 12345 if I enter this in the search it returns that its not entered even if it is, however if I enter SPR12345 then it finds it.

Likewise if it was actually SPR12345 and you enter SPR12345 then it wont find it, but if you put SPR 12345 then it will find it???

Hence the message box at the bottom of the code.

Just a little annoying and would like to resolve this,

Any help appreciated!!!!

Please Login or Register  to view this content.

[cytop]

Your logic seems to be:

1. Read the value to find from Cell G31
2. Ask the user for the value to find
3. Store that in G31
4. Search for the value read from G31 in step 1

Surely you should be looking for the value stored in CancelTest...?