View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Graham Y Graham Y is offline
external usenet poster
 
Posts: 66
Default Passing Controls on a form between modules

Hi
I've found I can use
On form...
General.ChangeDays datevalue, frmUpd
In General...
Sub ChangeDays(day1 As Date, frm As UserForm)


Don't know I missed that!

"Graham Y" wrote:

I need two forms, one for creating a record, one for updating it.
As all the validation etc will be identical, I thought it would be better to
put the code into one module. Then I could access the code from each form.
The forms have some check boxes on them, which are only visibly if there is a
Bank Hol that week. However I am having trouble accessing them from my
'General' module.
On form...
General.ChangeDays datevalue, frmUpd.Controls
In General...
Sub ChangeDays(day1 As Date, frm As Controls)
I want to say something like...
frm.lblLieu.Visible = True
but I get error 438
Object doesn't support this method or property,
So how do I do this
TIA