Create environment variable

Can you help?

I would like to know how to create, write to and retrieve values from an Environment Variable from within VBA.

I have code in a shared workbook accessed by several people over Sharepoint and am experiencing some code variable values being overwritten leading to the wrong value being written to the "Masterdata" sheet so am looking to store a certain value "outside" of VBA which I can guarantee belong to the individual user.

Thanks

You could put it in the registry

https://docs.microsoft.com/en-us/off...ting-statement

EDIT: Rory beat me to it!