Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send a frame control to a procedure as a parameter
I have code which will enable one of 10 frames on a form depending on a
control parameter which is predetermined. Here is my code which enables a fram control and all controls within it: Private Sub ActivateFrameAndControls(ByRef aFrame As Object) aFrame.Enabled = True ' Cycle thru all controls in the respective frame. For Each InnerCtrl In aFrame.Controls ' Enable each one. InnerCtrl.Enabled = True Next InnerCtrl End Sub My problem is that my calling code will pass th frame to the procedure, but the line "aFrame.Enabled = True" fails with the error "Runtime error 438. Object does not support this property or method". Here's my calling code: If bShowApp Then ActivateFrameAndControls (Me.fraApp) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send a frame control to a procedure as a parameter
Found the problem....it was in my calling code. It should have been:
If bShowApp Then Call ActivateFrameAndControls (Me.fraApp) -- | +-- JDMils | "JDMils" wrote in message ... I have code which will enable one of 10 frames on a form depending on a control parameter which is predetermined. Here is my code which enables a fram control and all controls within it: Private Sub ActivateFrameAndControls(ByRef aFrame As Object) aFrame.Enabled = True ' Cycle thru all controls in the respective frame. For Each InnerCtrl In aFrame.Controls ' Enable each one. InnerCtrl.Enabled = True Next InnerCtrl End Sub My problem is that my calling code will pass th frame to the procedure, but the line "aFrame.Enabled = True" fails with the error "Runtime error 438. Object does not support this property or method". Here's my calling code: If bShowApp Then ActivateFrameAndControls (Me.fraApp) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use VBA to control scrollbars in a Frame | Excel Programming | |||
user form and frame control | Excel Programming | |||
tab order in frame control | Excel Programming | |||
userform frame control | Excel Programming | |||
Passing parameter from Excel to stored procedure? | Excel Programming |