Passing a Range to UserForm

[beatdown23]

Hi, I am very new to Visual Basic and I am trying to pass the cell clicked on a worksheet to an UserForm and display this UserForm when any single cell is clicked. I need to store this cell on the form for later use.

To achieve it I am trying to use a property in the UserForm.

I have this code on my WorkSheet:

Please Login or Register  to view this content.

And this code in the UserForm:

Please Login or Register  to view this content.

But something is wrong and I don't know what it is... While debugging it says that error 91 "object variable or With block variable not set" was thrown at the line "LocalRange = rng"

Thank you very much

[OllieB]

Variable LocalRange is an object so should you not use Set LocalRange....?