View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default 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