Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Location
    England.
    Posts
    232

    Unanswered: Global or Workbook level variables.

    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.

  2. #2
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    in a module
    Beyond Limitation

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •