Global or Workbook level variables.

[DaveO]

Guys, I need to create a workbook, not worksheet level VBA variable.
Basically something that spans the whole of the workbook and that can be
accessed by each and every worksheet.

Any ideas on where I can specify this and how?

TIA.

[Stefi]

Make a search with "Workbook level variables" in Programming topic! Just
below your post you will see my old question with excellent answers from Tom
Ogilvy and Bob Phillips!

Regards,
Stefi


„DaveO” ezt �*rta:

> Guys, I need to create a workbook, not worksheet level VBA variable.
> Basically something that spans the whole of the workbook and that can be
> accessed by each and every worksheet.
>
> Any ideas on where I can specify this and how?
>
> TIA.

[Norman Jones]

Hi Dave,

In VBA help see:

'Understanding Scope and Visibility'

and

'Public Statement'

See also the examples provided there.

---
Regards,
Norman



"DaveO" <[email protected]> wrote in message
news:[email protected]...
> Guys, I need to create a workbook, not worksheet level VBA variable.
> Basically something that spans the whole of the workbook and that can be
> accessed by each and every worksheet.
>
> Any ideas on where I can specify this and how?
>
> TIA.