How to define Global Variable please help

[bimo]

Hello

this code generate emails and from a Pivot table, I am trying to make it user friendly so user can type in the message that would be included in the body of the message. I was told I need to define a global variable, can anyone help please ?

Thanks

Please Login or Register  to view this content.

[Mike1001]

A global variable is probably to be understood as a Public declaration
Outside of your Sub, you make that declaration by

Please Login or Register  to view this content.

This Public variable is valid across Subs or between Sub and UserForm without handing it over as a parameter.
Does that look like what you are trying to find?

[bimo]

yes broadly speaking. the variables I need to define need to be in Sub Remit_generate_mail() which is the starting macro, asking user to input the body message
but I want Sub AttachtoEmail() to recognise them and enter them on each email...make sense ?

[Izandol]

It is better to pass variables to routine directly.

Please Login or Register  to view this content.

this routine may now use sBody variable for message. Main routine will call in this way:

Please Login or Register  to view this content.

[Mike1001]

Don't confuse declaration of a variable with assigning a value to it!
That Public declaration would have to be outside of any Sub; assigning the value to it, however, could be done in your Remit_generate_mail() and would keep that value in AttachtoEmail() as well.

[bimo]

Hi Izandol, do you mind excusing my ignorance , I tried to apply your suggestion but I got an error "Function call on-hand side of assignment must return variant or object..can you see where I wrong please ?

Please Login or Register  to view this content.

[Norie]

This should fix that error, and some others.

Please Login or Register  to view this content.

[bimo]

Don't confuse declaration of a variable with assigning a value to it!
That Public declaration would have to be outside of any Sub; assigning the value to it, however, could be done in your Remit_generate_mail() and would keep that value in AttachtoEmail() as well.

Really ? that is good if it can be done..do you mind putting it in the Macros ,,,I am totally lost here ..

[bimo]

This should fix that error, and some others.

Please Login or Register  to view this content.

you are genius..Thank you