Results 1 to 8 of 8

Thread: [RESOLVED] Decalring global variables in VBA

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    46

    Resolved [RESOLVED] Decalring global variables in VBA

    Hi, I am quite new to VBA and i wan to know how can i declare a global variable in VBA. I understand tat i need to put this definition in a module, something like header files in C.. but what else is require in the module?

    can someone pls help me by giving me exactly the codes for declaring a golbal variable in a module?

    Global Variable : toolPath
    Type : String

    so do i define as Public toolPath As String?? anything esle n where to place it? thks

    btw, i am using VBA in access... so the "lifespan" of the variable will last till the entire application is closed right?

    thks
    Last edited by fulltime; May 26th, 2006 at 01:25 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width