Getting values from cells to userform to decide

[Alendi]

Hi everyone

I'm still trying to learn tricks

I've this code:

Please Login or Register  to view this content.

This code is giving me a error about object not stablished in MyRange = Worksheets("ZULIA").Range("B:B") line.

The idea is get a msgbox telling us that in range have a duplicate number and return column 4 same row value. as example, NVENTA = 345 the function must search in range B:B this value, if find it must return the value of same row column 4 of the founded value.

Thanks if somebody can help

[Norie]

Where and how have you declared MyRange?

[Alendi]

Hi Norie

There is variables declared:

Please Login or Register  to view this content.

Is there a mistake?
Thanks