Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my VBA module "module1" i have a global varible
Private global_var1 as boolean I initialize it in the main Subroutine global_var1 = false Then I call my userform, which has a cmdbtn "Doit" With Question_Form Load Question_Form .Show End With My userform cmdbtn code is Private Sub Always_Btn_Click() global_var1 = True Question_Form.Hide End Sub However, when my userform returns "global_var1" remains = false How do i pass global_var1 back to module1? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing Array of User Defined Type to Form | Excel Programming | |||
User Form value passing problem | Excel Programming | |||
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET | Excel Programming | |||
passing a range to a user defined function using a form | Excel Programming | |||
Passing Text from User Form to Spreadsheet | Excel Programming |