+ Reply to Thread
Results 1 to 3 of 3

Can not access my global variables

  1. #1
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Can not access my global variables

    I can not access my global variables can not get what I am doing wrong

    Thanks

    In userform I input the variable "ODEmail" that is the Column Letter for a column of emails

    In the UserForm code module I have

    Please Login or Register  to view this content.
    Then in a page module I have:
    Please Login or Register  to view this content.
    In a Standard Module I have
    Please Login or Register  to view this content.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Can not access my global variables

    Hi capson,

    From the wording of your question it seems you need to read about Scope (not the mouthwash) at:
    http://www.cpearson.com/excel/Scope.aspx

    I hope this helps. If not then attach your workbook so we can follow through the whole thing or a sample that shows the same problems.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Can not access my global variables

    Thanks that helped, I did not realize I had "Option Private Module" at top of the Module, I removed it and it works fine

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Global variables??
    By RustyNail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2015, 02:09 PM
  2. [SOLVED] Global Variables
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 12:10 PM
  3. Global Variables
    By Slyone2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2010, 12:20 PM
  4. Global variables
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2006, 11:05 PM
  5. Global Variables
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2006, 05:55 AM
  6. Global Variables
    By Francis Brown in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-27-2005, 02:20 PM
  7. global Variables
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2005, 03:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1