Public variables/declarations not passing to UserForm from Application Caller Button

Hi all,

I have an "Application Caller" Button that declares and sets the variables that I need to use in a UserForm.

The UserForm Variables are based on a range value, set when a particular Application.Caller button is pressed (Actually a shape on the Worksheet).

The Sub sets the UserForm button captions perfectly but when the variables are called within the command button routines I get a " Method 'Range' of object _'Global' failed " error

After the research I have done I am still no further advanced in figuring out the appropriate placement of the Public decalrations in the code.

Code for the UserForm "Application.Caller" Button (Standard Module) :

Please Login or Register  to view this content.

When the UserForm opens, The captions are pre-filled nicely, but when the command button on the form is clicked, the procedure gets the above-mentioned error at the line highlighted in red, and stops:

Please Login or Register  to view this content.

Something simple I've missed, for sure, but it baffles me.

Regards,
Martin

What is the value of invto when you get the error?

Also which workbook/worksheet should Range(invto) be referring to?

Hi again Norie.

The Answer to your first question cleared the brain blockage that I was having. I even forgot about testing the value to find a solution...

The Value of invto = Person I should Send the invoice to.... As required.

This gave me the solution to the code error.

I am actually being a bit lazy and butchering some old code that I have.

Solution: Don't be lazy and re-write the code!

New code working :

Please Login or Register  to view this content.

Thanks for your help.

Best Regards,

Martin