Global or Workbook level variables.

daveo61 · #1 (**permalink**) 10-20-05, 04:15

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.

vextout · #2 (**permalink**) 10-20-05, 16:23

in a module

shades · #3 (**permalink**) 10-20-05, 17:12

In a standard module. While in Excel hit ALT + F11, which opens the VBE. On the left is the Project Explorer window. Click on the name of the work FOLDER, and then go to INSERT > Module. A window will appear on the right, and you can post the code there.

DavidCoutts · #4 (**permalink**) 10-21-05, 06:09

Quote:

Originally Posted by shades

In a standard module. While in Excel hit ALT + F11, which opens the VBE. On the left is the Project Explorer window. Click on the name of the work FOLDER, and then go to INSERT > Module. A window will appear on the right, and you can post the code there.

and remember to make it public such as

Public sVar as String for example

Internet Services

Web Development

Digital Marketing

Consumer Tech