programme variables in excell VBA
 

Hello

Is there a variable area Text) in Excel VBA precsented under VBA
locals to be used for programmer purpose only (this may not could
interfer with excell or VBA) and how do I accessed it.
ex. me.uservariabes.variables1

it is urgent that this will be saved together with the file.

regards

Kurt

programme variables in excell VBA
 

Application.Names.Add "MYVARIABLE","MYVALUE"

This creates a name/variable MYVARIABLE with the value MYVALUE and it gets
saved with the workbook. BUT only string values may be used. In order to
query the value use:

Evaluate(Application.Names("MYVARIABLE").Value)

Without Evaluate, a formula rather than a value is returned.

Also. consider using Custom properties for variables that you do not want to
shore in cells.

"kurt hansen" wrote:

Hello

Is there a variable area Text) in Excel VBA precsented under VBA
locals to be used for programmer purpose only (this may not could
interfer with excell or VBA) and how do I accessed it.
ex. me.uservariabes.variables1

it is urgent that this will be saved together with the file.

regards

Kurt

programme variables in excell VBA
 

No there isn't.

If you want to preserve information across different sessions, there are 3
easy ways

- write it to another file an d the read it back at the session start
- write it to a workbook name and read it back at the start
- write it to a worksheet cell and read it back at the start.

The first two would need to cater for non-existence, the third only for
being empty.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kurt hansen" wrote in message
om...
Hello

Is there a variable area Text) in Excel VBA precsented under VBA
locals to be used for programmer purpose only (this may not could
interfer with excell or VBA) and how do I accessed it.
ex. me.uservariabes.variables1

it is urgent that this will be saved together with the file.

regards

Kurt

programme variables in excell VBA
 

? BUT only string values may be used.

Application.Names.Add "MYVARIABLE",1000

works as well.

Names also have a visible property if you don't want the user to be able to
alter them in Insert=Name=Define (as an example).

--
Regards,
Tom Ogilvy

"AA2e72E" wrote in message
...
Application.Names.Add "MYVARIABLE","MYVALUE"

This creates a name/variable MYVARIABLE with the value MYVALUE and it gets
saved with the workbook. BUT only string values may be used. In order to
query the value use:

Evaluate(Application.Names("MYVARIABLE").Value)

Without Evaluate, a formula rather than a value is returned.

Also. consider using Custom properties for variables that you do not want
to
shore in cells.

"kurt hansen" wrote:

Hello

Is there a variable area Text) in Excel VBA precsented under VBA
locals to be used for programmer purpose only (this may not could
interfer with excell or VBA) and how do I accessed it.
ex. me.uservariabes.variables1

it is urgent that this will be saved together with the file.

regards

Kurt