TextBox change event

[Dave H9]

Hi Folks,

Hope someone can help....

I have three columns of data 'C' - Name, 'D' - Company, 'E' - phone #

I have the following code to populate two text box's in a userform when the user completes the Name textbox -

Please Login or Register  to view this content.

My problem is that the above works perfectly until I get down to row 77. The names with higher row numbers don't seem to be found! I experimented by changes all the names to consecutive numbers with the same result.

Any help much appreciated.

Regards

Daveh9

[Sean Thomas]

try changing this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

your code maybe looking for the last row of data on the active sheet that may not be Sheet12, and therefore giving you the wrong number.

[Arkadi]

Hi Dave,

It would be great if you could upload the workbook to take a closer look and understand better. Have you monitored the range for rAll? I wonder if column C might be empty after row 77? Or at least somehow rAll is ending at that row. Again, easier if we can see the entire thing.

* good call Sean! I missed that completely.

[Dave H9]

Sean, you are a genius. Sorted first time

Max rep from me to you.

As always, thanks to you and this great forum.

Dave H9

[Sean Thomas]

Glad to help,
sometimes the simple errors are the hardest to spot, and can take the longest time to resolve. We all make them!
Thanks for the rep.

Sean