Setting Global Variable from a UserForm

Hi everyone,

I have a UserForm that runs when my excel project starts that prompts the user for two pieces of data: a username and a password (these are not for logging into the file itself, I need to use them to call web queries later). I want the UserForm to store both of these data in global variables, so that macros that are run in the future can refer to them and read their values. Unfortunately, I am very new to VBA and I cannot figure out what code I need and where exactly I need to put it. Here is my current code, where "authentication" is the name of the UserForm object, and the textboxes I use for entry are named "user" and "pass":

In "This Workbook"

Private Sub Workbook_Open()

authentication.Show

End Sub

In "authentication"

Private Sub submit_Click()

' Put a bunch of labels on cells

globalVarUsername = user
GlobalVarPassword = pass

authentication.Hide

End Sub

Declare your variable at the top of the module sheet - before any code

Use Public when declaring the variable to make it available to all macros with the Workbook
Use Private when declaring the variable to make it available only to macros on that Module Sheet
Place variable within the Macro to make it available to only that macro

Public Dim MyVariable1 as String
Public Dim MyInteger as Integer

Private Sub submit_Click()

' Put a bunch of labels on cells

globalVarUsername = user
GlobalVarPassword = pass

authentication.Hide

End Sub

Also suggest you have a look at
http://www.cpearson.com/excel/DeclaringVariables.aspx

You need to declare public variables (variables that have scope across all modules in a project) in a code module, not an object (workbook, sheet, form, class) module.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save