| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass Variables into Form's code
How do I pass a variable from a standard module into
the code behind a form, please? Eg I would like to pass "Global_HideSameCols" which is dimmed as Boolean, to the form "GetUserWkbk_PrintOptions" and use it in the initialise event: Private Sub UserForm_Initialize 'Fill the ListBox With GetUserWkbk_PrintOptions.ListBox1 If Global_HideSameCols = False Then .RowSource = "" etc Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Declare variables to a code? | Excel Discussion (Misc queries) | |||
| How to pass variables as arguments of a function | Excel Worksheet Functions | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| how to pass on different parameters to VBA Code? | Excel Worksheet Functions | |||
| Having one form show another form's input? | New Users to Excel | |||
![Stuart[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
