Worksheet needs certain cells to have a value before triggering the userform.

Hi,

Please could someone help me?

I have a worksheet (attached) and I would like certain cells to have values before triggering the userform.

I have added the details to the worksheet with arrows which hopefully will make it easier to understand (I hope)

Any help would be much appreciated.

Kind Regards

Dan

Hi mehmetcik,

thank you for your response but unfortunately its coming up with "Run Time Error 1004 - No cells were found

and its highlighting this line:

Please Login or Register  to view this content.

Any ideas?

Thanks again

Dan

Hi mehmetcik,

I've tried this code and it come up with a compile error - Variable not defined and it highlighted the Z =. So I put in Dim Z As Range, is that correct?

but then it come up with the same error as before and highlighted the same line.

Kind Regards

Dan

Hi mehmetcik,

That's perfect mate, thank you. I've managed to sort the error in my userform as well.

Thanks again

Dan