Hi everyone
I have several frames within a form I'd like change the attributes of depending on the click of a button
so, I have declared an object in module one
Public frametochange As MSForms.Frame
in Form1, I have many frames I'd like to change if a button is clicked.
in the button click event code I have
frametochange = me.frame1 '(or frame2,frame 3, etc, depending on the button that was clicked)
Then I'd like to call a subroutine to manipulate the attributes of the frame
sub displayframe()
frametochange.height = 200
frametochange width = 400
etc.
end sub
I'm getting a "compile error Invalid use of property on the statement on the assignment
frametochange = me.form1.
What am I doing wrong?
I have several frames within a form I'd like change the attributes of depending on the click of a button
so, I have declared an object in module one
Public frametochange As MSForms.Frame
in Form1, I have many frames I'd like to change if a button is clicked.
in the button click event code I have
frametochange = me.frame1 '(or frame2,frame 3, etc, depending on the button that was clicked)
Then I'd like to call a subroutine to manipulate the attributes of the frame
sub displayframe()
frametochange.height = 200
frametochange width = 400
etc.
end sub
I'm getting a "compile error Invalid use of property on the statement on the assignment
frametochange = me.form1.
What am I doing wrong?