Coding Error - VBA

**sgp** · 12-12-2011, 10:06 AM

Hi
I have tried to make some changes to a code and now it does not work! The coding is:
Code:

Please Login or Register  to view this content.

I have attached an example if that helps, thanks.

**watersev** · 12-12-2011, 10:24 AM

hi sgp, there some mistakes in the code (underlined)

Please Login or Register  to view this content.

**TMS** · 12-12-2011, 10:24 AM

Try:

Please Login or Register  to view this content.

Regards, TMS

**Bob Phillips** · 12-12-2011, 10:24 AM

Please Login or Register  to view this content.

**sgp** · 12-12-2011, 10:31 AM

Thanks watersev, TMS and Bob Phillips! - All solutions work great!

**TMS** · 12-12-2011, 10:33 AM

Note that I have changed this:

r = rFind.Row - 3

To this:

r = rFind.Row - 4

As the code seemed to put the information in the wrong cells.

Regards

**Bob Phillips** · 12-12-2011, 03:01 PM

Originally Posted by TMShucks

Note that I have changed this:

To this:

As the code seemed to put the information in the wrong cells.

Regards

I changed Range("C4") to Range("C3") - same reason.

**snb** · 12-13-2011, 08:15 AM

Wouldn't this suffice ?

Please Login or Register  to view this content.

To prevent non existing ID's you can fill a combobox with all valid ID's:

Please Login or Register  to view this content.

Re: Coding Error - VBA